AccessCopier - Copy data from one Access database to another »

Download AccessCopier Free Trial »     Buy AccessCopier Now »

Copy Access data from query to table

Click "Wizard - Query To Table" at task dialog.

Copy Access data from query to table - Task Window

then show the wizard.

1. Run a SQL Query.

Copy Access data from query to table - Run Query see ResultSet

2. Select a destination table and config fields.

Copy Access data from query to table - select table

3. Preview data.

Copy Access data from query to table - preview

4. Import.

Copy Access data from query to table - import

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.