Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO
Using ADO, is it possible to update more than 1 record
simultaneously in an Excel file? For example, lets say I have an excel file called test.xls. I have 3 sheets called "SH1", "SH2", and "SH3". Lets say 1 record is in cell A1 of sheet "SH1" and the other record is in lets say... cell B1 os sheet "SH2". If a request is sent from 1 source at the same time another request is sent from a 2nd source, will the file be updated or will I receive an error? Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO
"Todd Huttenstine" wrote ...
Using ADO, is it possible to update more than 1 record simultaneously in an Excel file? Hard to replicate in test (can you suggest a way?) but I think only one could update at one time so it is possible one would fail. With Excel, one can only get a lock type of 'batch optimistic' which should give you some idea of what your connection policy should be i.e. disconnected recordsets, client-side cursors, transactions, etc. With Excel I find updates are better done direct with SQL e.g. UPDATE or INSERT INTO syntax. After all, under the hood the recordset is doing the same! Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|