View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21 sal21 is offline
external usenet poster
 
Posts: 18
Default WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME

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