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