Export to CSV

#1

Are there any docs to explain how to export a table to CSV file? I can't
get it to work. I have created the ODBC but I get an error that I can't
modify my table because its in a read DB.

Any help would be greatly appreciated.

TIA,
Joe

#2

Have a look here it should help you get started

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

--

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

"jaylou" <jaylou (AT) discussions (DOT) microsoft.com> wrote

Quote:

Are there any docs to explain how to export a table to CSV file? I can't
get it to work. I have created the ODBC but I get an error that I can't
modify my table because its in a read DB.

Any help would be greatly appreciated.

TIA,
Joe

#3

Thank you!
This was much easier then the wizard!

Thanks again,
Joe

#4

Try www.sqlscripter.com to export data to text/csv.
It's free.

"jaylou" wrote:

Quote:

Are there any docs to explain how to export a table to CSV file? I can't
get it to work. I have created the ODBC but I get an error that I can't
modify my table because its in a read DB.

Any help would be greatly appreciated.

TIA,
Joe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Export to CSV

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Export to CSV - 04-24-2006 , 08:25 AM

Re: Export to CSV - 04-24-2006 , 08:33 AM

Re: Export to CSV - 04-24-2006 , 09:00 AM

RE: Export to CSV - 04-01-2007 , 02:40 PM