Merge multiple similar DB2 tables to 1 Access table

by

Posted on by

Want to transfer data from multiple similar DB2 tables to 1 Access table?

Try Withdata DBCopier, a DB2 to Access converter for Windows, Mac, and Linux, Copy DB2 data to Access, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Transfer data from multiple similar DB2 tables to a single Access table

Login to DB2 and Access -> Select source DB2 tables -> Set the target Access table -> Copy DB2 data to Access

Choose source DB2 database and logon.

convert DB2 data to Access data - Choose DB2 and logon

Choose target Access database and logon.

convert DB2 data to Access data - Choose Access and logon

Click “Convert Similar Tables” at task dialog.

Import data from multiple similar DB2 tables to 1 Access table - Task Window

then show the wizard.

1. Select similar DB2 tables.

Convert data from multiple similar DB2 tables to 1 Access table - open query results

2. Select a destination Access table and config fields.

Combine multiple similar DB2 tables data to a single Access table - select table

3. Preview data.

Migrage data from multiple similar DB2 tables to 1 Access table - preview

4. Import data from multiple similar DB2 tables to a single Access table.

Merge multiple similar DB2 tables to a single Access table - import

More about DB2 to Access converter

See also: