Appending 15 tables in Access2000 using VBA

ckentebe · April 14th, 2004, 11:29 AM

Hello,
I need to append 15 tables into 1 using vba (Access2000).
I know that I have to open a recordset for all the tables. What next ?
Any help would be

appreciated.

Steven · April 14th, 2004, 06:17 PM

Any particular reason you have to use VBA and recordsets?
Couldn't this be done with a simple INSERT statement?
such as:

Code:

INSERT INTO Table1 ( Field1, Field2 )
SELECT Field1, Field2
FROM Table2;

Or, if you want to do it in one big query..

Code:

INSERT INTO Table1 (Field1, Field2)
SELECT Field1, Field2 From Table2
UNION
SELECT Field1, Field2 From Table3
.........
UNION
SELECT Field1, Field2 From TableN

Steven

I am a loud man with a very large hat. This means I am in charge

sal · April 14th, 2004, 08:53 PM

Or you could create an append query and change the source table as you go.

Sal