Friday, March 9, 2012

how to import an excel table into sql server express?

Hi,
i have a table in an excel file. How can i import it into sql server
express?
Thanks
Ben
Ben
1) Linked Servers
2) OPENDATASOURCE command
INSERT INTO tbl
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\MyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$
"Ben" <b@.bn> wrote in message
news:%23hK40fbvHHA.3588@.TK2MSFTNGP06.phx.gbl...
> Hi,
> i have a table in an excel file. How can i import it into sql server
> express?
> Thanks
> Ben
>
>

No comments:

Post a Comment