copying data from Excel to SQL Server

Question

Hi everyone

                   How can we copy data from EXCEL to SQL Server database using Transact SQL. I know how to copy using import/export wizard and using package, but i need to copy data from EXCEL to SQL Server using T-SQL queries.

 

Thanks in advance

Answer 1

various  possibilities are described here

 

http://support.microsoft.com/default.aspx/kb/321686?p=1

---

Life is a race,tez nahi bhagoge to log kuchalke agey niklenge!

Answer 2

Here is an example:

 

INSERT INTO MyTable(column1, column2, column3)
   SELECT column1, column2, column3
      FROM  OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;HDR=YES;DATABASE=D:\Data\Info.xls',Sheet1$) AS imp;