Home All Groups Group Topic Archive Search About
Author
22 Nov 2005 4:23 AM
wendy elizabeth 26th
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?

AddThis Social Bookmark Button