Re: Auto refresh linked excel table from access database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Chris


pietlinden@xxxxxxxxxxx wrote:
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.

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

just put code behind a button to run it

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200902/1

.

Relevant Pages

  • Re: How to refresh page without prompt the "resend information...."?
    ... php newbie and no Javascript knowledge) And I press F5 the IE still ... dataupdate = setInterval, ... And the database data will update every second. ... set the auto refresh to get the data from database every minute. ...
    (comp.lang.php)
  • Re: How to refresh page without prompt the "resend information...."?
    ... I wrote a PHP page for user input the information to search the ... And the database data will update every second. ... set the auto refresh to get the data from database every minute. ... REQUEST to get the data from user input page. ...
    (comp.lang.php)
  • Re: How to refresh page without prompt the "resend information...."?
    ... I wrote a PHP page for user input the information to search the ... And the database data will update every second. ... set the auto refresh to get the data from database every minute. ... REQUEST to get the data from user input page. ...
    (comp.lang.php)
  • Auto refresh linked excel table from access database
    ... I have created a small simple database. ... I have a table in excel which queries ... My access database has a table which is linked to the ... Is there anyway I can make it auto refresh the data on ...
    (microsoft.public.access.externaldata)
  • Re: Real project -- general application structure
    ... on the webpage use periodically_call_remote to check the table to see ... if there are new updates. ... Or you can just do an auto refresh of the ... transitory and don't have any real need to be in the database, ...
    (comp.lang.ruby)