conection to excell cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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