Appending data

[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

 

[Ken Snell [MVP]]

You can run an append query using ACCESS macro or VBA code.

 

[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

 

[Ken Snell [MVP]]

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.

 

[Jeff Boyce]

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...