insert opendatasource( 'Microsoft.Jet.OLEDB.4.0 ',
'Data Source= "d:\book1.xls ";User ID=Admin;Password=;Extended properties=Excel 5.0 ')...sheet1$(f1)
select A from MyTable
-----------------------------
服务器: 消息 7399，级别 16，状态 1，行 4
OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0 ' 报错。
[OLE/DB provider returned message: 找不到可安装的 ISAM。]
OLE DB 错误跟踪［OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0 ' IDBInitialize::Initialize returned 0x80004005: ］。
------解决方案--------------------
opendatasource( 'Microsoft.Jet.OLEDB.4.0 ',
'Data Source= "d:\book1.xls ";User ID=Admin;Password=;Extended properties=Excel 5.0 ')...sheet1$
--> 去掉中间的多余空格
opendatasource( 'Microsoft.Jet.OLEDB.4.0 ',
'Data Source= "d:\book1.xls ";User ID=Admin;Password=;Extended properties=Excel 5.0 ')...sheet1$
------解决方案--------------------
insert opendatasource( 'Microsoft.Jet.OLEDB.4.0 ',
'Data Source= "d:\book1.xls ";
User ID=Admin;Password=;Extended properties=Excel 5.0 ')...sheet1$(f1)
select A from MyTable