VBA code to append table name into data table

M

MT_dma

I have to complie a database (I didn't create it) with many tables that have
a unique name that corresponds to data in another table in the same database
(ie table 63701e corresponds to data in the 63701g table). I want to append
all of the data in "e" tables together but the records do not include the
unique table name. Is there a piece of vba code that will loop through the
table names and append the table name into each table? Then when I append the
tables the table name will show up attached to the record in the table.

Thanks for your help.
 
Top