November 8, 2001 at 9:36 am
I need to output a query result in tab delimited format. I need the syntax. I use dbaseiii all the time and cvs once in a while, but I need to export this data using Tab delimited. Thanks
November 8, 2001 at 9:41 am
Have a look at DTS. You can easily export to a flat file in any format you need.
Alternatively, if ti's a one-off, you can copy and paste the results from query analyser.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 8, 2001 at 9:50 am
DTS is the easiest. You could probably make BCP work, but not worth it.
You can "save as" from Query Analyzer in csv, but then would need to open in dbase and export as tab.
Steve Jones
November 8, 2001 at 9:59 am
What I was thinking was that if it is a one-off, in QA,Query,Current Connection Options, Advanced, you can set the result output format as tab delimited, and copy and paste from there.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 8, 2001 at 10:48 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply