Import from Access into MS SQL Server 2012

Asked By 10 points N/A Posted on -

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.

Answered By 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.

Login/Register to Answer

Related Questions