Importing excel data to SQL Server using SSMS Import and Export Wizard requires the Microsoft Access Database Engine Component.
- 2010 version: https://www.microsoft.com/en-us/download/details.aspx?id=13255
- 2007 version: https://www.microsoft.com/en-us/download/details.aspx?id=23734
If you are getting an error stating “the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine”, try the 2007 version of the driver. More information: https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine
- Right-click the database node in SSMS, select Tasks -> Import Data…
- Choose Microsoft Excel as the Data source
- Choose SQL Server Native Client as the Destination and click through the rest of the wizard.