Export Records.

[JP]

Hi All,

I want to export records from a table to another table of
same structure in different access database.

Please advise.

Thanks.
JP.

 

[chas]

Hi John,

what you need to do is to create an append query in your
source database. Create a new select query based on the
relevant table and add all the fields to the grid, then
choose Query|Append query from the menu. You will see a
number of options in this dialog one of which allows you
to specify another database to append your records to.

hth

chas