Selectively importing enteries in Access database

[nrkazmi]

I have a made a database in MS Access XP. I enetr the data through the forms. I have to enter data sometimes at home too. Now since I do not have networking between the two computers, therefore I have placed a copy of the database on my home computer. When I make some enteries in my home computer access database and take it on a cd to my office the next day, how can I import the additional enteries made at home into the database copy present at office desktop. I mean to say that one day I have made 100 enteries in my office desktop and the same day I make another 20 enteries at home computer. Now the next day I want to import these 20 enteries into my office database so that the total enteries will become 120.

Is there any easy way to selectively import this data into access???

 

[dcx693]

You want to use an append query. I started typing out pages and pages of instructions, but there must be an example on the forums somewhere.

Basically, your query will be something like:
INSERT INTO tblOffice ( YourField )
SELECT tblHome.YourField
FROM tblHome LEFT JOIN tblOffice ON tblHome.YourField = tblOffice.YourField
WHERE ((tblOffice.YourField Is Null));

 

[nrkazmi]

I am a begginer so thats why I didnt understand all that code stuff. Please tell me something in simple easy terms which is practical and easy for me to implement.
Thanks

 

[dcx693]

OK, our ultimate aim is to add records from the home version to the office version. That will entail an update query.

To get to that point though, you'll need some way of identifying which records exist in the home version that do not already exist in the office version. Do you know how to do that?

 

[dcx693]

This article might help you. Ignore the part about Enforce Referential Integrity. How to Use the Find Unmatched Query Wizard

 

[nrkazmi]

Thanks for your help. I have gone through that article on microsoft site which you mentioned but I think I am too dumb to understand that. As far as to know which records have to be added. I have given them serial numbers. For example I have 120 serial numbers on office desktop. I now add another 10 enteries at home where I give them serial numbers 121 to 130. Now when I have to add I have to life the data from serial number 121 to 130.
If it is possible can you guide me step by step.

Thanks