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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Back
Top