Delete Data in an External table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shun - 28 Apr 2006 19:31 GMT

How do you delete data in a linked table? I have an excel file linked into
my access database but if I try to run a delete query on the linked table it
gives me this error message: Deleting data in a linked table is not
supported by this ISAM.

Any suggestions would be helpful.

Shun

Reply to this Message

Klatuu - 28 Apr 2006 19:53 GMT

I can't find the link to the background info, but modifying data in a linked
Excel file has been blocked by Microsoft. It is because of a lawsuit they
lost with someone who claims Microsoft violated a copywrite.

> How do you delete data in a linked table? I have an excel file linked into
> my access database but if I try to run a delete query on the linked table it
[quoted text clipped - 4 lines]
>
> Shun

Reply to this Message