 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / May 2005update linked table automatically
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? > Is there a way to update the link to an Excel spreadsheet without going > through the Linked Table Manager? Thanks. 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. > 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? > > > Is there a way to update the link to an Excel spreadsheet without going > > through the Linked Table Manager? Thanks. Hi David, This may help: http://www.mvps.org/access/tables/tbl0009.htm >Is there a way to update the link to an Excel spreadsheet without going >through the Linked Table Manager? Thanks. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. > Is there a way to update the link to an Excel spreadsheet without going > through the Linked Table Manager? Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.