Link query to Excel and back to Access as table??

[Guest]

I recently used Excel to link an Access query as external data to an Excel
worksheet, then linked that file back to Access to use as a table. To me,
this was a workaround way of having query results as a table. I set the
Excel file up to auto-refresh every 60 minutes, but the linked Access table
(based on the Excel file) does not seem to be updating properly. I have no
need to ever open the Excel file, so I figured the auto-refresh would handle
this. Does the Excel file need to be open in order to auto-refresh?

 

[Guest]

I do not entirely understand why you are going back and forth between the two
applications but either way, what about putting an import routine in your
database that would either auto update (with a timer) or have it update upon
a button click? You could import the Excel sheet/range without having it
open.

Hope this helps.