delet values from excel linked table

  • Thread starter יריב החביב
  • Start date
×

יריב החביב

Hello,

I have excel linked table in the access DB

and i want to delet the values in it after i run some other query.

So, as Jhon winson explain in other answer in this topic

i use Update Query to null the values in the excel linked table.

but when i run this query it tells me "Operation must use an updatable query"

and does nothing.

What is the problem ? What can i do ?

Thank's
 
D

Douglas J. Steele

Microsoft lost a lawsuit a few years back and were forced to remove the
ability to update linked Excel sheets.

Your options are to import the spreadsheet into Access, process it then
export it back, or use Automation to update the spreadsheet from Access.
 
×

יריב החביב

Very interesting . . .

I Can't understand way a lawsuit to remove this ability

Thank's anyway
 

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

Linked Excel File won't update 1
Linked Excel Table, Update Table 1
Operation must use an updatable query 2
Comma separated values in a single field 1
Update Query from Access 2003 Linked Table 1
Linking Tables 4
Linked Excel tables opened exclusively 4
Linked Table Manager - Query using an Excel file 2

Top