how to import an excel table into sql server express?

B

Ben

Hi,

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

Uri Dimant

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$
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Importing Excel data with macros to SQL server 1
import Excel worksheet to SQL Server table 7
QueryTables.Add() not returning text from SQL Express table 1
Excel as front end and SQL Server as back end 0
VBA Excel data to SQL Sever table 1
import data from excel command button 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top