470,632 Members | 2,025 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,632 developers. It's quick & easy.

Updating data from a handheld computer

470 256MB
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?
Aug 28 '09 #1
2 1663
8,804 Expert 8TB
@CD Tom
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.
Aug 29 '09 #2
CD Tom
470 256MB
I'll give that a try, thanks
Aug 29 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Paige | last post: by
2 posts views Thread by Philipp Lenssen | last post: by
2 posts views Thread by David T. Ashley | last post: by
1 post views Thread by Harlan Messinger | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.