update linked table automatically

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

Guest

Is there a way to update the link to an Excel spreadsheet without going
through the Linked Table Manager? Thanks.
 
Can you be more specific?
When do you want to do link?
Will the Excel file always be in the same folder and have the same name?
 
The tables will not move. They're for an instrument usage log, and after
about a month, the current table will be static, and a new one will be active
and changed. I want to update the links when the db is opened, mainly at the
time the monthly report is created.

I missed the MVP article that John posted. I'll check that code as well as
the replies here. Thank you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to link single excel spreadsheet to multiple access tables 1
Linking Access 2003 table to Excel 2003 spreadsheet 1
Imported spreadsheet data from Excel to Access 1
Links need to be refreshed? 2
Re-link an existing xls linked table to a different excel file 4
Data not showing from Linked Excel 3
Linked tables no longer linking after move from Access 97 -Access 3
Linking Access and Oracle Database 2

Back
Top