Auto refresh linked excel table from access database

[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.

 

[pietlinden]

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.

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

just put code behind a button to run it

 

[Chris O'C via AccessMonster.com]

Build a query based on the linked table. Build a form with this query as the
recordsource. Put a button on the form with this line of code:

Me.Requery

Every time you push the button the latest data in the Excel spreadsheet will
show in the form.

Chris

 

[Chris O'C via AccessMonster.com]

He/she just wants to show the latest data from the spreadsheet. Relinking
the table is overkill.

Chris