View Single Post
 
Old 10-31-2018, 04:56 AM
shabbaranks shabbaranks is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
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
Reply With Quote