Thx for your reply I hope using a temporary table will not decrease the performance to much
Note: the grid_id is not the id/autonumber of the table, it is not a primary key it is some kind of code
quote:Originally posted by mmcdonal
You need to pull the data into a local table first, then run the update from the local table.
Create the table.
Then in your code:
Run a delete query on it to make sure there is no data in it.
Append the data from the text file.
Do the update.
Run the Delete query again to empty the table.
In any event, you want to change the local table's ID field (Can you do this?) to the text file's ID field value in each case where they are not equal? Won't this get stuck in an infinite loop?
Did any of that help?