o******r
发帖数: 259 | 1 用CDaoDatabase打开Excel 文件，
update记录都可以，
偏偏delete就出exception,
DAO Call Failed.
m_pDAODatabase->Execute( V_BSTR(&var), COleVariant((long)nOptions))
In file daocore.cpp on line 1544
scode = 800A0E21
Error Code = 3617
Source = DAO.Database
Description = Deleting data in a linked table is not supported by this ISAM.
难道设计这个接口的人就从来没想过有可能要delete一条记录吗？
数据记录都放在一个Excel文件里，
在VC里用CDaoDatabase/CDaoRecordset去查询，更新
有什么办法吗？ | o******r
发帖数: 259 | 2 发现跟Dao没有关系，
试着直接用ODBC，用excel file做data source
update还是可以，
但delete 一条记录时，报错
“Deleting data in a linked table is not supported by this ISAM.
State:S1000,Native:-5410,Origin:[Microsoft][ODBC Excel Driver]”
Microsoft网站上，同样的报错出现在delete csv database
If you are deleting records:
Database Results Error
"Description: [Microsoft][ODBC Text Driver] Deleting data in a linked tab
le is not supported by this ISAM.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers"
解释是：
The OD
【在 o******r 的大作中提到】
: 用CDaoDatabase打开Excel 文件，
: update记录都可以，
: 偏偏delete就出exception,
: DAO Call Failed.
: m_pDAODatabase->Execute( V_BSTR(&var), COleVariant((long)nOptions))
: In file daocore.cpp on line 1544
: scode = 800A0E21
: Error Code = 3617
: Source = DAO.Database
: Description = Deleting data in a linked table is not supported by this ISAM.
| o******r
发帖数: 259 | 3 换成access file就能删了，
nnd
【在 o******r 的大作中提到】
: 发现跟Dao没有关系，
: 试着直接用ODBC，用excel file做data source
: update还是可以，
: 但delete 一条记录时，报错
: “Deleting data in a linked table is not supported by this ISAM.
: State:S1000,Native:-5410,Origin:[Microsoft][ODBC Excel Driver]”
: Microsoft网站上，同样的报错出现在delete csv database
: If you are deleting records:
: Database Results Error
: "Description: [Microsoft][ODBC Text Driver] Deleting data in a linked tab
|
|
