 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Jan Borawski
Guest
|
 Posted: Tue Jul 12, 2005 12:38 pm Post subject: Excel updates with ADO |
 |
|
I want to update an Excel data presented in DBGrid using D7 ADO components
and receive permanently message 'Operation must use an updateable query'
regardless of component ADOQuery or ADOTable is used. My settings are:
ADOConnection
-----------------
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:...test1.xls;
Mode=ReadWrite;
Extended Properties="Excel 8.0;HDR=NO;IMEX=1;ReadOnly=False"
ADOQuery
------------
SQL='SELECT * FROM [Data$]'
There is no such a message when the ADOQuery.LockType is set to
ltBatchOptimistic, but changes are not saved this time anyway.
I have searched groups looking for similar problems and there are plenty
like this, but no satisfied answer. Microsoft KB (like Artikel No. 257819
does not help as well.
My Excel document is not used by any other application.
Thanks for any assistance.
Jan
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
