Exporting data from a table

jkj2001 · Post by **jkj2001** » Thu Apr 11, 2002 12:33 pm

What's the appropriate tsql syntax for exporting data from one of my tables in quoted, delimited format? Something so that the resulting text file looks like:

"field1 value"^"field2 value"^"field3 value"
"field1 value"^"field2 value"^"field3 value"

etc. Thanks.

Post by **mark** » Thu Apr 11, 2002 12:51 pm

Use the -f ^ option. You may also want the -q option.

See http://www.thunderstone.com/site/texisman/node299.html

For fancier formats you can write a small vortex script to export about any format you could come up with.

Texis User · Post by **Texis User** » Mon Feb 05, 2007 8:01 am

This link is not avl http://www.thunderstone.com/site/texisman/node299.html.

Post by **mark** » Mon Feb 05, 2007 12:21 pm

Try http://www.thunderstone.com/site/texisman/tsql.html