Thursday, March 29, 2012

export every table into a separate csv

Within sql2000 is there a wizard/function whereby a user can select all
tables and export the data into separate csv files?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_REPLYtechsupport@.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?
>

No comments:

Post a Comment