First, you need and install AccessToMsSql.
AccessToMsSql is a data conversion tool that helps DBA and database programmer convert Access data to Sql Server database.
Access To MS Sql Server – 3 Steps
Click “Import From Table” button.
then show the Import Single Table form.
1. Config Source.
2. Config Destination.
3. Config Fields.
4. Import, Show import progress.
More about AccessToMsSql – the tool to convert Access data to SQL Server.