Access 97

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Is it possible to live link an Excel file to a Table in Access so as the
Excel file is altered it goes through to the Table.

Thanks

Bruce
 
When you link from Access to Excel (File | Get External Data | Link), Access
is actually reading the Excel spreadsheet, so any changes you make there
will be read in Access.

Unfortunately, it's no longer possible for Access to update a linked Excel
spreadsheet.
 
Back
Top