Can I use a CSV file to update an Access table via update query

[Pack10]

I am currently importing a large table into Access for an update query. Ideally I would like to link to the CSV file instead of importing it.
I link to the CSV file with no issue...however, when I chage the imported table to the linked CSV so I can use that value to update my Acccess table I receive an error message That "Updating a linked table is not supported by ISAM"... I am not updating the linked table, I am using the value from the linked table to update Access.
Here is the query code generated....


UPDATE [Combined Quality Tracker] INNER JOIN [Data_x_CSV] ON [Combined Quality Tracker].[Normalized CAS ID] = [Data_x_CSV].[CAS ID] SET [Combined Quality Tracker].[Booking Region] = [CIS Incremental Statuses];

 

[Pack10]

I'll save time here, i just found out that linked CSV file wont work...


Update query or delete query may not succeed in Access if the query reads data from a linked-text file
Article ID: 824159 - View products that this article applies to.
This article applies to either a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file, and to a Microsoft Access project (.adp) file. Moderate: Requires basic macro, coding, and interoperability skills.
Expand all | Collapse allSYMPTOMSIf you try to update a Microsoft Access table by using an update query that reads data from a linked-text file, the update may fail and you may receive the following error message:
Updating data in a linked table is not supported by this ISAM.Note for Microsoft Office Access 2007 users
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
503616If you try to update an Access table by using a delete query that reads data from a linked-text file, the deletion may fail and you may receive the following error message:
Deleting data in a linked table is not supported by this ISAM.Note for Microsoft Office Access 2007 users
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
503617Back to the top | Give Feedback
WORKAROUNDTo work around this problem, import the text file to the Access database and then run the update query or run the delete query.