update access from excel
 

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

update access from excel
 

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


"?B?c2FsMjE=?=" wrote :

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