Most efficient way to merge 13 tables in A.mdb into one table in B.mdb

E

EagleOne

2003/2007

I have attempted imports with all 13 tables selected but they came in as 13 separate tables.

TIA EagleOne
 
E

EagleOne

I should have stated that all of the tables have exactly the same structure - but all of the
information is different therefore there are no duplicates.

TIA EagleOne
 
D

Douglas J. Steele

Link to the 13 tables (rather than import them).

Create a Union query joining together the tables.

Use that Union query as the basis of a MakeTable query to create the new
table in the second database.

Unlink the 13 tables once you're done with them.
 
E

EagleOne

Doug,

Thanks for your advice. Does it still apply if all the structures are exactly the same and all of
the data is not duplicative therefore there is nothing to link?

EagleOne
 
P

pietlinden

Doug,

Thanks for your advice. Does it still apply if all the structures are exactly the same and all of
the data is not duplicative therefore there is nothing to link?

EagleOne

Huh? If the structures are not the same, then merging the data is
kinda hard... that's a prerequisite. The data isn't duplicated?
Great, it'll merge nicely.
 
T

Tony Toews [MVP]

The structures are the same, the data is not duplicative.

Each time I do an append query, I get key violations.

Ah, is the primary key an autonumber field? If so include all the
other fields except the primary autonumber key in your append query.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top