Bulk import data from SQL files to Access tables at one time

Want to bulk import SQL files into Access tables at one time?

Try Withdata software FileToDB, a SQL to Access converter for Access for Windows, MacOS, and Linux, Easy and Fast, Even other type database SQL.

• 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.

Download Withdata FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Bulk import SQL files into Access tables

Login to Access -> Choose SQL files -> Set Access tables -> Import SQL files to Access tables

Choose Access and logon.

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

Select the “SQL” file type.

then show the wizard.

1. Select a folder that constains SQL files.

2. Config first SQL file importing options.

3. Set “Import Type”.

4. Map Access tables to SQL files.

5. Summary. Set “Convert Rows” and “Skip Rows” if need.

6. Import SQL files to Access tables, 1 file to 1 table, one by one.

View imported data in Access table

---

More about SQL file to Access converter

See also:

• Import data from SQL file to Access
• Batch import data from multiple SQL files to a single Access table