append to separate database

[DrOktagon]

First. This board is awesome, especially Trevor G.

Here's what I need to do. I have a database with several tables, all of them have identical fields, but different records. I would like macro code that appends them all together into a table in another database. For example, the following code works to append them all to a table in the same database, but I need to append them to a table in another database because i don't have enough available memory. How can I adapt the code?

Thanks


Sub AppendData()
DoCmd.RunSQL "Insert Into table1 Select * from WOAD1995"
DoCmd.RunSQL "Insert Into table1 Select * from WOAD1996"
DoCmd.RunSQL "Insert Into table1 Select * from WOAD1997"
DoCmd.RunSQL "Insert Into table1 Select * from WOAD1998"
End Sub

 

[Joe4]

Here is what I would recommend doing.

Link all those tables to your DESTINATION database. Then run your append code directly in that Destination database.

 

[DrOktagon]

Works! Thanks Joe