Update Query using CSV file

[tacieslik]

OK, here goes...

I have a linked table to a CSV file called SALES.csv
Within my Access 2000 DB i have another linked table called tblMaster. I also have an update query that when run should look for a field that exists in both linked tables called fldProdCode, if they match the values from 2 fields within the CSV are deducted from the same fields within tblMaster. If the CSV is a normal table (not linked and within the DB) this query will work fine, but when linked, I get the error "Updating data in a linked table is not supported by this ISAM"?

Any ideas. I had a look on this forum, but I was not very successful. Any help form you Pat?

 

[tacieslik]

Thanks Pat,

So even though I'm not updating the CSV file, it has to be updateable? I gave in with this in the end anyway and I now run a make table query on the CSV data, run an update query and then delete the table. This seems to work fine and is not too slow.

Thanks again.

 

[MarcusAntonius]

Is there a way to automate this process without the need for user interaction (during the update)?

 

[MarcusAntonius]

It's ok, I found out - set warnings to off.