SQL -  how to write table into file

tommym121
tommym121 used Ask the Experts™
on
I would like to write each record of a table into a line within the file.
I would like to be able to select the seperator character for the columns within the file.

Any idea?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Please check this post on how to do this..
(assuming you are using sql server management studio)

http://stackoverflow.com/questions/6354130/is-there-a-select-into-outfile-equivalent-in-sql-server-management-studio
Commented:
1. Right click the database
2. Select Tasks>>Export.
3. Follow the wizard.

Author

Commented:
Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial