conection to excell cells

[Andy]

Hello,
I have several calculated data in different excel files, which I want to
summarise in an Access Table. Is it possible to fill the the access
Fields(cells) with the values of these Excel cells? I want to do it in a way,
that I conect the single access cell with a single excel cell. It is
important that the values can be updated, if the calculations in the excel
sheets will be changed.
Thanks for your help.

 

[Douglas J. Steele]

Assuming the spreadsheet is set up properly, Access can link to Excel
spreadsheets and treat them like tables (through Files | Get External Data |
Link tables). Unfortunately, you can no longer update the Excel spreadsheets
using this approach.