Import Excel SQL Server 2008 R2

Question

I am using SS 2008 R2 and Office 2010 on 64-bit Windows 7. I am trying to use the import wizard to import an Excel sheet into a spreadsheet. I get this error:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) 

I am very new to this and really appreciate any help I can get.

Perhaps I am also mistaken (and therefore getting an error), because if I choose the Import 64-bit Files Wizard, there will be no choice for Microsoft Excel. So, I'm trying to use a 32-bit wizard. Does anyone know how I can make this work? Thanks in advance!

For other users: For those who have the same problem, the answer that a1ex07 suggested for Office 2010 is. Check this topic The provider 'Microsoft.ACE.OLEDB.12.0' is not registered on the local computer

Answer 1

For those who have the same problem, the answer was a1ex07 for Office 2010. alex07 answer The provider 'Microsoft.ACE.OLEDB.12.0' is not registered on the local computer ... this answer originally came from kd7.

Answer 2

I had the same problem trying to import an Excel file using SQL Management Studio (SMS 2012). I use the 64-bit version of everything, including Office 2013. This solution from social.msdn.microsoft.com resolved this for me:

The problem you are likely to encounter is the Import / Export Wizard, which runs as a 32-bit version. This is probably due to the fact that you right-click on the database and click on import, and since SSMS is a 32-bit program, it will start 32-bit processes. Try to explicitly launch the import / export wizard (64-bit) by clicking "Start" - "Program Files" → "Microsoft SQL Server 2012->" Import and Export Data "(64-bit) to import data from 64-bit data source.

Noral kulman

Answer 3

file may be Excel 2007 try installing 2007 Office System Driver: Data Connectivity Components