|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
dts packageI 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? |
|||||||||||||||||||||||