Quote:
Originally Posted by ArviLaanemets
Link the Excel table (Read-only link, so the table in Excel workbook doesn't get locked, and can be edited) into Access.
In Access, create a procedure which updates Access table with data from linked Excel table. Run this procedure from some Access database event (button click, form open, etc.)
|
Hi - thanks for your response. I have set this up and when I tested it (updating a copy of the linked table) it worked fine. If I try to update the live table I get the message "operation must use an updatable query" yet it is an update query?
Thanks