conection to excell cells

A

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.
 
D

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.
 
Top