Digital Volcano Forums
     Simple MDB Merge
       multiple tables 		 
 Posted June 17, 2008 at 23:16

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
 Posted June 17, 2008 at 23:44

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).
 Posted June 21, 2008 at 09:11

DV

Yes, sorry about that - you currently can only do one table name at a time.
Good point about the _Merge prefix too.
 Posted August 27, 2009 at 21:13

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
 Posted March 9, 2010 at 16:31

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.
 Posted March 9, 2010 at 17:01

Rene

I have read the workaround in other thread. Sorry!
Page 1/1 | Previous
Post Your Comments:
Your Name:
Topic:multiple tables
Comments:
Please enter Security Code:
 

Pahoehoeforum 0.81 ©2010 DigitalVolcano Admin