Export Records.

  • Thread starter Thread starter JP
  • Start date Start date
J

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.
 
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
 
Back
Top