sal21
Instead of Importing, you need to use Data GetExternalData to a create a
query that points to those tables. Then you only need to refresh in Excel
(which you can schedule at certain time intervals) and the Excel sheets will
be up to date. See here
http://www.dicks-clicks.com/excel/ExternalData.htm
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"sal21" wrote in message
...
My actually prob is:
At every day i import the records of this MDB in the various sheet named
with the same name of the table, for example at 8.00 am of morning
During the same day SOME value of this MDB (in this file the field that
they
be updating a NOTE_BOU, SPESE, DATA_ATT, NOTE and NOTA_LIBERA) only
this
field are uppdated from the external appication in real time.
How I can make to update the cells of excel at every time that the value
in
the MDB is updating?
Note: in the sheet is present a unique id in column "S" (actually is hide)
and the same id is present in the MDB in the field SERVIZIO
here is the MDB file
http://www.gssitaly.com/prova.zip