delet values from excel linked table

  • Thread starter Thread starter יריב החביב
  • Start date 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
 
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
 
Back
Top