导入EXCEL
SELECT * INTO db_news.dbo.test FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:/工作/test.xls', [Sheet1$])
Excel 转Dataset
导入EXCEL
SELECT * INTO db_news.dbo.test FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:/工作/test.xls', [Sheet1$])
Excel 转Dataset