Auto refresh linked excel table from access database

  • Thread starter Thread starter JW37
  • Start date Start date
J

JW37

I have created a small simple database. I have a table in excel which queries
external data source. My access database has a table which is linked to the
excel table. I know I can refresh the data using tools / database utilities /
linked table manager. Is there anyway I can make it auto refresh the data on
either opening of the database or macro / button on switchboard.
 
I have created a small simple database. I have a table in excel which queries
external data source. My access database has a table which is linked to the
excel table. I know I can refresh the data using tools / database utilities /
linked table manager. Is there anyway I can make it auto refresh the dataon
either opening of the database or macro / button on switchboard.
Click to expand...

This will work...
http://www.mvps.org/access/tables/tbl0009.htm

just put code behind a button to run it
 
Back
Top