Maybe I am having a brain spasm. In any event, I don't know what I am doing wrong...
Using Access 2007, I am trying to create an update query that will update an Access table with data contained in a linked .csv file.
Anything I try gives me an error message saying that updating data in a linked table is not supported by this ISAM. I am not trying to update the linked .csv file. I am trying to update a legitimate Access table.
The SQL generated by the query for example is:
[POS YTD Data] is an Access table
[February POS] is a linked .CSV file.
Help would be appreciated...
Using Access 2007, I am trying to create an update query that will update an Access table with data contained in a linked .csv file.
Anything I try gives me an error message saying that updating data in a linked table is not supported by this ISAM. I am not trying to update the linked .csv file. I am trying to update a legitimate Access table.
The SQL generated by the query for example is:
Code:
UPDATE [POS YTD Data] INNER JOIN [February POS] ON [POS YTD Data].ASIN = [February POS].ASIN SET [POS YTD Data].[Feb POS] = [February POS]![Shipped Units];
[POS YTD Data] is an Access table
[February POS] is a linked .CSV file.
Help would be appreciated...