dts import wizard

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 certai
n
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?Hi
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\MyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$
"wendy elizabeth 26th" <wendyelizabeth26th@.discussions.microsoft.com> wrote
in message news:E8BA9079-FAD3-4726-BBB6-557E7C8DC32C@.microsoft.com...
>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?