N/APosted on - 01/10/2015
Hi! I'm trying to import databases from Access into MS SQL Server 2012 via master of import in MS Access. The problem is that he doesn't offer me driver of Access in it. I installed office to the server, because I though it might help, but no result. Please advise what should I do to see Access driver there. Thank you.
Import from Access into MS SQL Server 2012
You should be able to import the Access Data from the MS SQL Server Management Studio:
Create a New Database in your SQL Server to import the Access Data
Right click on the New Database and Select Tasks–> Import Data
This will open up the Data Import Wizard
Select the MS Access data source. If this Data Source is not listed, then download and install OLEDB (MSDASQL) from the Microsoft site
Now specify the database in the next screen (you can also browse and choose the database)
Choose Tables to be Imported and then Click Next
Choose Run Immediately and then click Finish on the Next Screen
The Data Import Wizard will show progress or errors.