I have 10 data bases all with the same structure that I need to
combine. They are large enough so that copy and append takes a great
deal of time.

That's 10 Access databases? How many tables in each one? Is this
something you need to do only once or do you do regular update? I
think we need a little more detail to go on.

I wrote an article on this, and there's a code download. It's NOT a utility, but
it might serve as a good starting point for writing your own code for merging.

http://www.databasejournal.com/featu...le.php/2236471

There's an updated download at my site
http://amazecreations.com/datafast/daaug.aspx
--

Danny J. Lesandrini
dlesandrini@hotmail.com
http://amazecreations.com/datafast


<rwd@jvkcpa.com> wrote ...[color=blue]
>I have 10 data bases all with the same structure that I need to
> combine. They are large enough so that copy and append takes a great
> deal of time.
>[/color]

Sorry, there are 10 tables that have the exact same structure. I want
to combine them.

can't you use an outer join to determine which records are unique and
then import the results to the destination table? Use the Find
Unmathed query wizard and then turn that query into an append query.