MS SQL Server - export every table into a separate csv

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

export every table into a separate csv

Jack Vamvas

2006-10-24, 6:33 pm

Within sql2000 is there a wizard/function whereby a user can select all
tables and export the data into separate csv files?

Sue Hoegemeier

2006-10-24, 6:33 pm

Don't think there is a wizard to do this but the following
article has the information to get you started on doing this
in DTS:
How to export all tables in a database
http://www.sqldts.com/default.aspx?299

Make sure the check the link to another article on the site:
How to loop through a global variable Rowset
http://www.sqldts.com/default.aspx?298

-Sue

On Mon, 2 Oct 2006 16:28:12 +0100, "Jack Vamvas"
< DEL_TO_REPLYtechsupp
ort@ciquery.com> wrote:

>Within sql2000 is there a wizard/function whereby a user can select all
>tables and export the data into separate csv files?
>
>

Sponsored Links