全國最多中醫師線上諮詢網站-台灣中醫網
發文 回覆 瀏覽次數:915
推到 Plurk!
推到 Facebook!

excel做为数据源的问题--不能删除记录

尚未結案
alex_zeng
一般會員


發表:1
回覆:0
積分:0
註冊:2003-04-23

發送簡訊給我
#1 引用回覆 回覆 發表時間:2003-06-27 09:25:45 IP:202.181.xxx.xxx 未訂閱
ADO连EXCEL都连上了,连上之后,但是数据库中的记录不能删除,出现ISAM不支持在链接表中删除数据。 我很急,能不能帮我解决一下。谢谢
ha0009
版主


發表:16
回覆:507
積分:639
註冊:2002-03-16

發送簡訊給我
#2 引用回覆 回覆 發表時間:2003-06-27 09:49:49 IP:61.30.xxx.xxx 未訂閱
你好: 這是 ADO 關於 Excel 支援的說明,你看看吧。 < class="code"> When the Microsoft Excel driver is used, data source tables are opened as read-only by default, and can be opened by only one user at a time. Even though tables have read-only status, however, applications can perform insertions and updates for Microsoft Excel tables. When an application performs a Save As command on Microsoft Excel data through the Microsoft Excel driver, the application should create a new table and insert the data to be saved into the new table. Inserts result in an append to the table. No other operations can be performed on the table until it is closed and reopened. Once the table is closed, no subsequent insert can be performed because the table is then a read-only table. It is possible to update values when using the Microsoft Excel driver, but a row cannot be deleted from a table based on a Microsoft Excel spreadsheet, so updates are not considered officially supported by the Microsoft Excel driver.
alex_3
一般會員


發表:0
回覆:1
積分:0
註冊:2003-05-20

發送簡訊給我
#3 引用回覆 回覆 發表時間:2003-06-27 21:18:03 IP:202.181.xxx.xxx 未訂閱
版主你太偉大了﹐我這總是想了很久了﹐我是ALEX_ZENG 真是太了不起了 謝謝﹗﹗﹗﹗﹗
系統時間:2024-07-03 19:38:29
聯絡我們 | Delphi K.Top討論版
本站聲明
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。
2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。
3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇!