ADO

[Todd Huttenstine]

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

 

[Jamie Collins]

...

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.

--