Transfer data from multiple similar SQL Server tables to same Access table without programming

by

Posted on by

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

Using DBCopier, a native GUI tool, you can transfer data from multiple similar SQL Server tables to single Access table easily and fast, just a few mouse clicks.

Supports Windows XP, 7, 8, 10, 11, 2003, 2008, 2012

Here you can download and install DBCopier.

Transfer data from multiple similar SQL Server tables To same Access table

Choose source SQL Server database and logon.

convert SQL Server data to Access data - Choose SQL Server and logon

Choose target Access database and logon.

convert SQL Server data to Access data - Choose Access and logon

Click “Convert Similar Tables” at task dialog.

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

then show the wizard.

1. Select similar tables.

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

2. Select a destination table and config fields.

Extract multiple similar SQL Server tables data to 1 Access table - select table

3. Preview data.

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

4. Import.

Import data from multiple similar SQL Server tables to 1 Access table - import

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBCopier – the tool to copy SQL Server data to Access

30-day free trial Download DBCopier