Question/Topic:
How to copy or move records from one database to another?
How to copy/move record(s) between databases:
How to create databases with the same structure:
how to create a duplicate
database/table.
-
Source and destination databases have to be of the same structure.
-
Open the source database.
-
Select the item on the table of contents (left panel)(1).
-
On the Record menu click (2)
1. Copy Record to Another DB (to copy record), or
2. Move Record to Another DB (to move record)
-
Select target database in the Copy/Move Record window. Click OK.
How to copy/move all/selected records between databases:
-
Source and destination databases have to be of the same structure.
-
Load Source database.
-
On the Advanced menu click Maintenance
-
In the Maintenance window click
1. Copy Records (to copy records)(1), or
2. Move Records (to move records)(2)
-
Select target database in the Copy/Move Record window. Click OK.
Note: define filter if you want to copy/move a group of records.
Similar questions:
How to take data from one data base and copy to other data
base?
|