WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME

[Guest]

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 are: 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

 

[Dick Kusleika]

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

 

[sal21]

Ok! i have make that...
But if update the MDB file why the sheet of excel not is updating wit
the new value changed in MDB

 

[Dick Kusleika]

Post the macro you're using.

 

[sal21]

http://www.gssitaly.com/l0785_def.zip

the MDB is linked on my first pos

 

[Dick Kusleika]

sal21

Can you narrow it down to which macro does the import?

 

[sal21]

Here is the .bas to import in Excel from Access file...
Acctually to is present in the project that you have...
Note:
Change the path.
Naturally if you have another way is welcome. In effect during the
import the process is very, veryslow...)


+-------------------------------------------------------------------+
|Filename: ESTRACT_ALL.zip |
|Download: http://www.excelforum.com/attachment.php?postid=2767 |
+-------------------------------------------------------------------+

 

[Dick Kusleika]

"Invalid attachment specified"

I've downloaded the workbook, just tell me the name of the procedure and the
module that it's in.