transfert from access to access db

[katana82]

Hi Group
we have to copy data from 2 databse where tables arent identical.

each week we have to upload all data from heas office database and add it to
local database keeping all data add localy and whitout duplicate.

anybody know how to do it?


thank you

Luc

 

[FoFa]

Is the other DB on a network so you can "see"it from the local one? Also it is a DB that has either a native connection or ODBC/OLE DB connectivity?

 

[katana82]

hi

both file arent on the same network and both file
arent access file with the same table in it.

luc

 

[FoFa]

If they can't see each other to be linked, than you will have to export something like a CSV file from one, and import it into the other one. I would setup a work table (or temp table, but I perfer work table) that you can import the data into. Then you can write append (insert) or update queries to your main table depending on the data.