473,386 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Updating data from a handheld computer

489 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 1816
ADezii
8,834 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
489 256MB
I'll give that a try, thanks
Aug 29 '09 #3

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

Similar topics

7
by: Paige | last post by:
I have a database on my local machine that I make entries and corrections on. I'd like to be able to upload that to my server and have that update the database that's on the server. What I've been...
7
by: Chris | last post by:
Here's the situation: I work at a scientific institution and I have a portable electronic device which is used to take measurements. The device produces a very small amount of numerical data,...
2
by: Philipp Lenssen | last post by:
I'm looking for samples which make use of the XHTML Basic doctype and handheld CSS. Anybody know some good URLs which use plain CSS to layout the page (as opposed to many graphics)? I want to...
1
by: Colin Graham | last post by:
My skills are in VB. Net/SQL Server and i have touched on PDA development mainly as a tester. i am aware of using webservices for functionality. I have been given a task to develop a solution...
1
by: Siva | last post by:
Hi, I have a 3 tier ASP.Net app for a handheld which needs to fetch orders from database via a DAL and populate it in a gridview using objectdatasource. In the search page I have a few parameters...
2
by: David T. Ashley | last post by:
I noticed that my brokerage house as well as gmail present different (i.e. simpler, more compact) interfaces when I surf them with my handheld (a Blackberry) versus a desktop or laptop computer. ...
4
by: Luvin lunch | last post by:
Hi, I've developed a worklist system in Access and I plan to deploy four copies of it to the four users that need it. I said I'll be deploying copies because there is no shared network in the...
1
by: Harlan Messinger | last post by:
English Wikipedia allows registered users to define custom styles. I created a set of styles inside a @media handheld wrapper to see if I could override the default absolute positionings and floats...
1
by: noodyn | last post by:
Hi, I want to have a table for screen layout like this: One Two Three Four One Two Three Four When i access the page via handheld, i want that table to look like this: One Two
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.