dts import wizard  
Author Message
tenlrt





PostPosted: Mon Nov 21 23:28:41 CST 2005 Top

SQL Server Developer >> 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 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?

SQL Server158  
 
 
Uri





PostPosted: Mon Nov 21 23:28:41 CST 2005 Top

SQL Server Developer >> dts import wizard Hi

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\MyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$





>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?