Updating data from a handheld computer

[CD Tom]

Here's what I'm trying to do. First I export an existing table to a .txt file and move it to a handheld computer, it is then added to a database on that handheld. Data is inputted into the handheld, when all data is inputted the data is exported to another .txt file and transfered to the main computer. What I want to do is update the table on the main computer with the data that has been collected on the handheld. I know I could load the handheld data into a temp table in the main database and then go through each record matching it to the key and updating each column until I've gone through all records. Is there a better way to do this that could update the main database table?

[ADezii]

Here's what I'm trying to do. First I export an existing table to a .txt file and move it to a handheld computer, it is then added to a database on that handheld. Data is inputted into the handheld, when all data is inputted the data is exported to another .txt file and transfered to the main computer. What I want to do is update the table on the main computer with the data that has been collected on the handheld. I know I could load the handheld data into a temp table in the main database and then go through each record matching it to the key and updating each column until I've gone through all records. Is there a better way to do this that could update the main database table?

Assuming the Text File is either in a Fixed or Delimited Format, you can Link the Text File, then perform your Updates from this Linked Table.

[CD Tom]

I'll give that a try, thanks