Auto refresh linked excel table from access database

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

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.
Click to expand...

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

just put code behind a button to run it
 

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

BeforeUpdate on linked table 2
Link query to Excel, then back to Access?? 1
How do I refresh external data in Excel via linked table in Access 1
Refreshing Data Daily From a Linked Excel Spreadsheet 2
Link a table from web page? 1
question about linked table feature on access 2000 3
refresh linked query 5
Linked Excel File won't update 1

Top