Sunday, February 19, 2012

excel to mssql

Hi,
is there any way to port excel data into mssql through mssql management studio express edition or by using excel itself.
thanksUm... T-SQL do ya?

Insert into MyTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\MyExcelWorkBook.xls;HDR=YES',
'SELECT * FROM [MyWorkSheet$]')|||Why don't you use DTS to import data from Excel to MSSQL?

No comments:

Post a Comment