Want to import data from each table in a SQL file to a separate Access table?
Try Withdata FileToDB, a SQL to Access converter, Import each table data in a SQL file to a separate Access table, Easy and Fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Import SQL to Access locally and privately, avoid uploading SQL file(s) to online services.
- Support Windows, Linux, and macOS.
Import data from each table in a SQL file to a separate Access table
Select tables in SQL file -> Set Access tables -> Import SQL data to Access
Choose Access and logon.

Click “Wizard – 1 File To N Tables” at task dialog.

Select the “SQL” file type.

then show the wizard.
1. Open a SQL file, select tables.

2. Show existing Access tables, choose “Import Type”.

3. Set Access tables.

4. Show summary, set “Convert Rows”.

5. Import data from each table in a SQL file to a separate Access table.

View imported data in Access table

More about SQL file to Access converter
See Video: Import each table data in a SQL file to a separate Access table at one time

