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

03/15/2012 15:56 Darkness™#1
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).
03/15/2012 16:09 Dr.Abdelfattah#2
you mean normal text like at itemdata or skilldata (at media pk2)
or text like INSERT ............ (query) ?
03/15/2012 16:13 Darkness™#3
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.
03/15/2012 16:18 Dr.Abdelfattah#4
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 ?
03/17/2012 13:17 miaulicious#5
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 :)