Merging Access tables and relations
Merging Access tables and relations
(OP)
hey there!
does anyone know a tool that is able to merge the tables of two access-databases (same structure) including the relation-structure and the indexes?
= how to import all the data records including structure from db1 into db2.
it would be fine if special selections could be made (like only certain data records....) - but need not be necessary.
thx in advance
does anyone know a tool that is able to merge the tables of two access-databases (same structure) including the relation-structure and the indexes?
= how to import all the data records including structure from db1 into db2.
it would be fine if special selections could be made (like only certain data records....) - but need not be necessary.
thx in advance
RE: Merging Access tables and relations
Kathryn
RE: Merging Access tables and relations
thank you but this is not exactly what I need...
'cause Access imports the data correctly, but not into the existing tables
like:
myDB1: Table "Customer"
myDB2 (which I want to be included in myDB1):
-> after importing
myDB1: Table "Customer" (orig.), AND Table "Customer2" (from myDB2)...
...could you give me any suggestions???
thx
RE: Merging Access tables and relations
Kathryn
RE: Merging Access tables and relations
...would be a step in the right direction...
but there should be a tool which manages that kind of stuff, shouldn't it?? ...I mean I have got about 50 tables and the relations are complicated. I would have to spend a lot of time finding out which data has to be appended first...(because of the referenc. integrity) -> the data should be consistent after the procedure...
This is a common problem, isn't it? ...
RE: Merging Access tables and relations
System for managing that kind of stuff, yes it does exist, and is a developing tool you by in addition to your Access license.
"Office Developer Edition" (ODE), which among other interesting things, contain a tool for creating and managing replicas, ie creating more than one physical database, which is perceived by the user as the same database. You can configure this to do data-syncronisation between the replicas at given intervalls, and when put up correctly, it will save you a lot of time.
If your merging is something you'll have to do often, you might want to consider this tool. It does not however solve your immediate challenge of merging the existing information.
Another interesting thing with ODE, is that you can distribute your Access-apps with "Access Run-Time-Engine", where the clients does not need to have Access installed to use the app.
Roy-Vidar
RE: Merging Access tables and relations