Append

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
I think I've got it. Just insert into archive select * from ...

looping through tables.
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query question - Is this scenario possible? 1
Max & Min Dates 0
append query 1
Access 2010 append query to SQL is very slow 0
Speeding up Append Queries 3
Append to two different tables 23
Append Query To Table 3
Access 2007 - append query only appending 0 rows??? 0

Back
Top