|
|
#2
10-31-2018, 02:29 AM
|
|||
|
|||
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.) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| EXCEL IF STATEMENT Help | bksmith | Excel | 3 | 07-27-2021 07:01 AM |
| Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement | Gwilson | Excel | 3 | 04-13-2017 11:31 AM |
| Help! figuring if statement with 2 vlookups excel 2013 | MWATKINS7111 | Excel | 3 | 02-24-2017 12:58 AM |
| select statement in macro | Nicolette | Excel | 1 | 11-19-2013 01:38 AM |
 Select statement to a new document
|
ishaw | Word | 1 | 10-17-2011 02:23 AM |
Windows 8 
Office 2016
Threaded Mode