bcp character output surrounded by double quotes 1

[dbmsguy]

I am trying to move data from one dbms to another. in my target dbms, I need to have double quotes around the character data and the columns delim by a comma....

I can't seem to get bcp to put the data out in this format .. has anyone done this before or suggest a way to get this done?

Paul

http://www.dbmsguy.com

 

[hmckillop]

You can use a format file to delimit the columns with a ",".
As far as outputting SQLCHAR fields with double quotes around them you do that via DTS.
In fact I would probably do all of it in DTS.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[hmckillop]

another quick way is to use Microsoft Excel, link the data and then save as a CSV, it will do all that you ask. (obviously only practical as a one off unless you want to use VBA or macros.)

"I'm living so far beyond my income that we may almost be said to be living apart

 

[dbmsguy]

Excellent suggestion.....

the DTS pkg seems to solve my problem....

the idea of excel is probably a good one, however I have millions of rows, so it falls down there.

Thanks for the help! A star for youi

Paul

http://www.dbmsguy.com