Updating data in a linked table is not supported by this ISAM

G

Guest

I have a link to a text file. I want to update an existing access table with
the data in the text file. However, I get the above error message. When I
click on the help file, it says that the linked table cannot be updated, only
new records can be added.

However, I'm not doing anything to the linked table. I'm just copying data
from that table to an existing access table:

UPDATE Students INNER JOIN STUDENTCONTACTINFO ON Students.DistrictID =
STUDENTCONTACTINFO.Field1 SET Students.FirstName =
[studentcontactinfo].[field2];

StudentContactInfo is the text delimited file. Students is the Access table.
 

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

Updating Data in a Linked Table Not Supported 2
Deleting data in linked table not supported by this ISAM 3
not supported by ISAM 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linked data from a text file 1
Delete Data in an External table 1
Importing and modifying exisiting primary key data 3
Invalid Argument Error when importing .csv to Linked Table 1

Top