multiple tables

Other bits and pieces and old stuff!
Post Reply
User avatar
Benno

multiple tables

Post by Benno »

Hello. This is a great tool. I'm merging tables from multiple databases in Access 2003. All the databases have the same tables (~100). So far I've had to manually merge each table. Is there a way to specify to merge each table? "*" doesn't work.

Thanks again,

Benno
User avatar
Benno

Post by Benno »

Also, not appending "_Merge" on the new table would be an excellent additional option (like if I'm creating the new tables in a new database).
User avatar
DV

Post by DV »

Yes, sorry about that - you currently can only do one table name at a time.
Good point about the _Merge prefix too.
User avatar
MemoMurcio

Post by MemoMurcio »

The thing it�s that I have identical tables with identical ID�s. Is it possible to have this application in MDB_MERGE

THANKS
User avatar
Rene

Post by Rene »

The tool doesn't merge if the tables have identical ID's?
In my case are autonumerical (autoincrement) ID's, and I can't merge, even if I don't care about the ID's column.
User avatar
Rene

Post by Rene »

I have read the workaround in other thread. Sorry!
Post Reply