Import Access to MS SQL

Import Access database to Microsoft SQL Server

This tutorial will help you to convert accdb, mdb databases to SQL and then add it to SQL Server. We will use the script from https://github.com/miguel93041/accessmysqlconverter

1. Install python and pip on your computer
2. pip install –no-cache-dir –upgrade accessmysqlconverter
3. python -m accessmysqlconverter.application
4. Now follow the instructions on the screen and select the appropriate .accdb or .mdb file.
5. Afterwards a .sql file will be generated. You can then import this file into your database in SQL Server Management Studio.