SELECT * into hbj
FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="h:\excel\hbj.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...[Sheet1$]
在查询分析七中执行出错!
...全文
413打赏收藏
不能用jet.oledb4 导入excel数据到 局域网中 的 DB Server吗?
SELECT * into hbj FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="h:\excel\hbj.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...[Sheet1$] 在查询分析七中执行出错!