Hi Guys,
I know you're all Access-Smart, so I figured this would be the best place to post this question.
What I Did:
*I created an Excel/CSV table and imported it as a linked table into Access. (This table has 6 fields which also occur in another larger table of 12 fields.)
*I linked the small imported table to the larger table - I used a one-sided join based on an identifier in the small table, as I want to use it to update 5 fields in the larger table. So I created this Select Query to only grab those records that exist in the small table.
*I attempted to run an update Query based on the data in the small table to update data in the large table.
*Access complains that, "Updating data in a linked table is not supported by this ISAM."
Is that because I didn't create a new table when I imported the CSV, but just linked to the file instead?
Anyone suggest any workarounds? Manual data entry for this number of records is more time consuming (and prone to error) than automating this.
Thanks!
I know you're all Access-Smart, so I figured this would be the best place to post this question.
What I Did:
*I created an Excel/CSV table and imported it as a linked table into Access. (This table has 6 fields which also occur in another larger table of 12 fields.)
*I linked the small imported table to the larger table - I used a one-sided join based on an identifier in the small table, as I want to use it to update 5 fields in the larger table. So I created this Select Query to only grab those records that exist in the small table.
*I attempted to run an update Query based on the data in the small table to update data in the large table.
*Access complains that, "Updating data in a linked table is not supported by this ISAM."
Is that because I didn't create a new table when I imported the CSV, but just linked to the file instead?
Anyone suggest any workarounds? Manual data entry for this number of records is more time consuming (and prone to error) than automating this.
Thanks!