Macro on startup to refresh linked excel table

[scott-atkinson]

Guys,

I wonder if you can help me, I have a Access linked table to an Excel sheet that contains an SQL, to ensure that my database has the correct data I have to manually refresh the excel sheet prior to opening Access, is there a way that I could create a Macro on database satrt-up that would refresh the Excel sheet?

 

[boblarson]

If you open the Excel sheet and then go to DATA / GET EXTERNAL DATA / DATA RANGE PROPERTIES you should be able to set the check box that says: Refresh Data on File Open which should refresh the data every time someone opens the database.

 

[scott-atkinson]

Bob,

Thanks for your help that works a dream.