This technique sets up a worksheet that ALWAYS reads from the mdb  you've
specified.
When you select the sheet with this external data, there is a toolbar that pops
up that
has an "Refresh All" button to update the sheet with the latest data  from the
mdb.
If you're trying to update it with VBA, then you use:

ActiveWorkbook.RefreshAll
it's been a while since I designed my sheet (a couple of years), but if I
remember correctly,
you either retrieve the entire Access table, or you retrieve data based on a
query stored in the MDB.