2,496
社区成员
发帖
与我相关
我的任务
分享Excel 导入表出错
我用这个语句把Excel 内容导入一个表dylen,老出这样的错（但是有时候可以）。请帮解决一下，谢谢。。
select * into dylen from OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\wu.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$
出错：
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
select * into dylen from OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\wu.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$
出错：
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
...全文
请发表友善的回复…
发表回复
78hgdong 2007-07-20
- 打赏
- 举报
你是往临时表里导入数据,没有加 # 号,要注意..
select * into #dylen from OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\wu.xls";User ID=Admin;Password=;Extended properties=Excel 5.0;Persist Security Info=false')...Sheet1$
select * into #dylen from OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\wu.xls";User ID=Admin;Password=;Extended properties=Excel 5.0;Persist Security Info=false')...Sheet1$
dfj0001 2007-07-20
- 打赏
- 举报
必须数据库和文件在同一台机器上。
h98458 2007-07-20
- 打赏
- 举报
把Excel 5.0改成Excel 8.0
