Merging two data bases

[kstarnes]

I have two seperate files with the same type of data. Each file is sorted into multiple batches. The first file is a current data base still being used that was created in an older version of access. The new database has some records, but is in a newer version of access. I need to know how to copy the records from the currently used but older version of access into the new database. I need for the records to be active to run reports. Sorry if its a basic question.
New job.

 

[RuralGuy]

What are the two versions of Access you are dealing with?

 

[kstarnes]

I think that the older version is Access 2000 and the newer 2003- both versions are saved as access 2000 versions but the older may have been created from an access 98 file somewhere along the way.

 

[RuralGuy]

Have you tried just linking to the other db table?

 

[kstarnes]

what I have ended up doing is importing the old into the new...but this results in seperate batch tables. I have also tried creating an append query but haven't gotten it to work.

 

[RuralGuy]

Is this a recurring operation? If so, then you will probably want to create a 3rd table and append both of the other table to it and then create it again each time you need it. Can you link to the "older" table?

 

[kstarnes]

When I link, all I get is an import of the old records on a new batch table by themselves...without the new ones. When entering new records they go onto the original batch table so that new records and records existing on the new access file don't ever co-exist with the old records fromt the old access file. This would be less of a problem if I could set all of the new records to be input into the imported or linked batch table, is there any way to do that? Unfortunately the input seems to be flawed as well- I don't think any of the records on the new database were ever input, just imported from elsewhere.