Any way to Append Records to tbl in External db? (1 Viewer)

E

Egad

Registered User.

Local time

Today, 08:11

Joined

Jun 8, 2004

Messages

12

• Jan 18, 2005

• #1

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.

 

R

Rob.Mills

Registered User.

Local time

Today, 10:11

Joined

Aug 29, 2002

Messages

871

• Jan 18, 2005

• #2

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.

 

E

Egad

Registered User.

Local time

Today, 08:11

Joined

Jun 8, 2004

Messages

12

• Jan 18, 2005

• #3

Thanks.

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