Is there any way to extract Tables from sql to a txt file

[Darkness™]

Hi.

well, as the title says, i want to know if theres a query for extract tables from database to a .txt file, like to import (BULK INSERT).

[Dr.Abdelfattah]

you mean normal text like at itemdata or skilldata (at media pk2)
or text like INSERT ............ (query) ?

[Darkness™]

I mean, extract the whole Table as a .txt file.

Because, i know i can Import the .txt files to an table, so i guess there is any way to extract tables to a .txt file.

[Dr.Abdelfattah]

look for text like (media pk2) just view the table data for example and select all (select first row and go to last row click shift and click on last row) then click Ctrl + C (Copy)
and past to a text (notepad or whatever)
Is that what u need ?

[miaulicious]

right click your desired DB > Tasks > Export Data and you have the options to select Destination as Flat File, that`s .txt

hope it helped