SELECT * into newtable FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";UserID=Admin;Password=;Extended properties=Excel 5.0')...xactions
...全文
276打赏收藏
能给一个已运行通过的实例演示sql server 导入excel吗?
SELECT * into newtable FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Finance\account.xls";UserID=Admin;Password=;Extended properties=Excel 5.0')...xactions