First, you need download and install AccessToMsSql.
AccessToMsSql is a data conversion tool that helps DBA and database programmer import Access data to MS SQL Server database.
Bulk/Batch Import Data From Access To MS SQL Server – 4 Steps
Click “Wizard – Import All Tables” at task dialog.

then show the wizard.
1. Open an Access file.

2. Select a database schema.

3. Select tables to import.

4. Import.


