dynamicall linking access and excel

[eric]

I need to have multiple excel spreadsheets change cells
in an access database, and then have that access database
then turn around and change cells in the excel
spreadsheets.

Does anyone know how to do this?

Thanks, I am stumped, and would really appreciate any
answer.

-Eric

 

[Guest]

Can you link to the excel files? (get external data - link tables
then you can simply run update queries.

 

[onedaywhen]

...

I need to have multiple excel spreadsheets change cells
in an access database, and then have that access database
then turn around and change cells in the excel
spreadsheets.

Short answer: ADO code called from the Excel workbooks.

Long answer: post more details.

--