transfer data

[bigfoot53]

hello all,

what is the best way to transfer data from a table on one pc to another pc "pc are not in the same place and have no way of connecting" meed to merg data from one to the other. the table is the same will just need the data . one pc is the master and the other is a data enry pc.the master needs to take the data "pref on floppy and put it into the table while keeping alll other data that is already in the table .



thanks..

 

[Dave Eyley]

One way to do this would be to -

Create an empty database next to the one you're taking the table from.
Import the table into the new database and save it to floppy.

Take the floppy to the database where you want to merge the data.
Open the receiving database in database view (ie no forms open) and import the table into the database.
Now you have the new table in the same place as the 'home' table, you can paste the records across.

If the table names are the same, Access will add a '1' to the end of the incoming table so it won't overwrite the 'home' table.

Look out for any Primary key violations. ie duplicate Primary keys trying to get into one table.


HTH

Dave E

 

[Smev]

I may be wrong but there must me a better way than "cut and paste".

 

[Smev]

Try running an update query between the original database and the new database.

 

[Dave Eyley]

An append query, once the floppy disc is in the same PC, would probably do the trick unless there were duplicate PKs involved.
Once these were sorted out.......no problem.

Cut and Paste wouldn't be that difficult either. Depends on the amount of data to transfer, I suppose.

Anyway, Bigfoot's got a choice.

Dave E