Link query to Excel, then back to Access??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
This is an Excel question rather than an Access one, but in general
it's a pretty safe assumption that no file will do anything unless
something opens it!
 
Back
Top