Any way to Append Records to tbl in External db?

[Egad]

Is there any way to have an append query take the records and append them to a table in another Access Database file? I'd like to have only current records in the main database but keep the others in an archive database.

 

[Rob.Mills]

When you switch a query to an append query it prompts for the table as well as a data source. That's where you can specify the file.

 

[Egad]

Thanks.

It works! That takes care of a big problem for me.