ExcelBanter - how to import an excel table into sql server express?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to import an excel table into sql server express? (https://www.excelbanter.com/excel-programming/392621-how-import-excel-table-into-sql-server-express.html)

Ben

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

Uri Dimant

how to import an excel table into sql server express?

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
...
Hi,

i have a table in an excel file. How can i import it into sql server
express?
Thanks
Ben

All times are GMT +1. The time now is 01:56 PM.