dynamicall linking access and excel

  • Thread starter Thread starter eric
  • Start date Start date
E

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
 
Can you link to the excel files? (get external data - link tables
then you can simply run update queries.
 
...
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.
Click to expand...

Short answer: ADO code called from the Excel workbooks.

Long answer: post more details.

--
 
Back
Top