Want to transfer data from multiple similar SQL Server tables to 1 Access table?
Using MsSqlToAccess, you can transfer data from multiple similar SQL Server tables to single Access table easily and fast, just a few mouse clicks.
Here you can download and install MsSqlToAccess.
Transfer data from multiple similar SQL Server tables To same Access table
Click “Wizard – Import Similar Tables” at task dialog.
then show the wizard.
1. Select similar tables.
2. Select a destination table and config fields.
3. Preview data.
More about MsSqlToAccess – the tool to copy SQL Server data to Access
30-day free trial US$79.0