Import from Access into MS SQL Server 2012

Asked By Steven R McKee 10 points N/A Posted 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.

• Status: Open
• Question Views: 694
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Vicky Endor 0 points N/A #182111

Import from Access into MS SQL Server 2012

You should be able to import the Access Data from the MS SQL Server Management Studio:

 

1. Create a New Database in your SQL Server to import the Access Data
2. Right click on the New Database and Select Tasks–> Import Data
3. This will open up the Data Import Wizard
4. Select the MS Access data source. If this Data Source is not listed, then download and install OLEDB (MSDASQL) from the Microsoft site
5. Now specify the database in the next screen (you can also browse and choose the database)
6. Choose Tables to be Imported and then Click Next
7. Choose Run Immediately and then click Finish on the Next Screen
8. The Data Import Wizard will show progress or errors.

About Vicky Endor

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/13/2015
• Question Category: MS Access