update access from excel

[sal21]

My actually prob is:

is possible to update automaticlly the cells of the sheet L0785_TOTALE and
the table TOTALE of MDB after i have insert a value in the txtbox marked (see
the image).
the unique value for every sheet is in the column S acctually is hide.
the unique value for table TOTALE is in the column SERVIZIO.
Tks for all.
Note:_ the module DB_ACCESS is only a test not consider it.
http://www.gssitaly.com/l0785_def.zip
http://www.gssitaly.com/prova.zip

htTP://www.gssitaly.com/txtbox.gif

tks from Italy

 

[keepITcool]

just on the theory...
haven't downloaded your files...

TOTALE.. sounds like totals to me..
totals should be computed not stored.

Create a linked table in Access and link to the excel sheets.
create a query to generate your totals..



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >