G
Guest
I inherited an Access 97 DB with 425 tables, all in the same format, dealing
with transactions for one day. How do I roll it up into one? With an append?
Select into? Insert?
I was thinking of using a form and DAO to loop through the table collection and
roll them up into one archive. Each table has a date field (with the same date)
So I would retaining all the information.
I think the tables are downloaded from an ADP thing and it seems ridiculous to
have 425 tables with identical structures when they can all be archived into
one?
Anyone know the comand to put a few together?
(e-mail address removed)
with transactions for one day. How do I roll it up into one? With an append?
Select into? Insert?
I was thinking of using a form and DAO to loop through the table collection and
roll them up into one archive. Each table has a date field (with the same date)
So I would retaining all the information.
I think the tables are downloaded from an ADP thing and it seems ridiculous to
have 425 tables with identical structures when they can all be archived into
one?
Anyone know the comand to put a few together?
(e-mail address removed)