Page 1 of 1
multiple tables
Posted: Tue Jun 17, 2008 11:16 pm
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
Posted: Tue Jun 17, 2008 11:44 pm
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).
Posted: Sat Jun 21, 2008 9:11 am
by DV
Yes, sorry about that - you currently can only do one table name at a time.
Good point about the _Merge prefix too.
Posted: Thu Aug 27, 2009 9:13 pm
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
Posted: Tue Mar 09, 2010 4:31 pm
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.
Posted: Tue Mar 09, 2010 5:01 pm
by Rene
I have read the workaround in other thread. Sorry!