MS SQL Server Tools - dts package

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

dts package

wendy elizabeth 26th

2005-11-22, 3:24 am

I want to import an excel spreadsheet 2000 into a sql server 2000 database.
When I import the columns from the excel spreadsheet, I am not always certain
what columns, and how many columns are included in each excel spreadsheet in
advance.
Thus is there a copy to automatically import all the columns from an excel
spreadsheet into a sql server 2000 database using the DTS import wizard? I
would like to be able to setup this copy metthod without having to declare
all the sql server 2000 columns in advance.
Thus, how would you do this?

Sponsored Links