query is not updatable;; urgent

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
 
R

Rob Parker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
not in criteria fails 2
Using Office Forms and dynamically updating the excel backend 0
Query not updatable - advise on how to change it 4
Query (Recordset) is Not Updateable 1
Embedded Excel into Word with Tables 0
Imported Query Not Updatable - Identical Front End Databases 1
Update Query Fails due to Source table not being Updatable 2

Top