Link query to Excel, then back to Access??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nyrblue2 - 24 Jul 2007 16:54 GMT

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?

Reply to this Message

John Nurick - 24 Jul 2007 22:59 GMT

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!

>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,
[quoted text clipped - 3 lines]
>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?

--
John Nurick - Access MVP

Reply to this Message