Bulk/Batch Import Data From Access To SQL Server

Shiji Pan

13 years ago

Want to bulk import data from Access to SQL Server ?

Using DBCopier, a native GUI software, a Access to SQL Server converter, you can bulk import data from Access to SQL Server easily and fast.

Here’s how to.

Bulk import data from Access to SQL Server

Choose source Access database and logon.

Choose target SQL Server database and logon.

Click “Wizard – Import All Tables” at task dialog.

then show the wizard.

1. Open source Access .

2. List target SQL Server tables.

3. Select SQL Server tables to import.

4. Bulk import data from Access to SQL Server.

You can save/load session to run “Access to SQL Server” importing repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

click “OK” button.

2.Load Session.

Click the “Open Saved Session” in task window, select a session file.

then show the wizard form, click a few “Next” to bulk import Access to SQL Server.

You can run “Access to SQL Server” importing in command line.

When you save session, you can click “Save & Make Batch File”.

The “Save & Make Batch File” form shows.

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\DBCopier"
DBCopier task="C:\Users\pansh\Documents\test.ula" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

You can run “Access to SQL Server” importing automatically at specific time.

On Linux/macOS, you can use Crontab.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.