query is not updatable;; urgent

  • Thread starter Thread starter lee
  • Start date Start date
L

lee

i am trying to use an update query in access to update records in
excel spreadsheet whiich i have linked to the database... i am getting
an output as "query is not updatable"

any idea why? i donot want to import excel spreadsheet into an access
table every time since there are 21 tables... can you help> thanks
 
Linked Excel spreadsheets are non-updateable. This has been the case since
a court decision several years ago. Access can read data from a sheet, but
cannot alter it. Your alternatives are to use the TransferSpreadsheet
method, or to write some VBA automation code to perform the updates.

Rob
 
Back
Top