Appending data

  • Thread starter Thread starter Martin Wilson
  • Start date Start date
M

Martin Wilson

Hello,

Is there a way that I can programmatically append the
data from one table in Access to another table in the
same database?

Thanks,

Martin Wilson
 
Hi Ken,

A query sounds good but is probably not practical because
I will actually need to append the data from 75 tables to
one single table so a program is probably best. Do you
happen to have a sample of appending code?

Michelle
 
What does the number of tables have to do with using a query or not using a
query? You could run the query multiple times, sequentially for each source
table. Give us a bit more info and we can suggest some code to do what you
seek.
 
Martin

In addition to Ken's comments, I would ask if this is a one-time effort, or
if you had intended to be doing this regularly? Either way, as Ken points
out, provide more info for more specific suggestions...
 
Back
Top