Microsoft.ACE.OLEDB is not registered
Hello.
I'm using VS Framework 4.5 C#.
Trying toget data sfrom Excel.
I've gor a trouble - “The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine” - i tryed to install some soft from msdn, but i had no result.
I tryes this CS:
"Provider=Microsoft.ACE.OLEDB.14.0; Extended Properties="Excel 14.0; HDR=Yes";Data Source={0};",
"Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties="Excel 12.0; HDR=Yes"; Data Source={0};",
"Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties="Excel 8.0; HDR=Yes";Data Source={0};",
"Provider=Microsoft.Jet.OLEDB.4.0; Extended Properties"Excel 8.0; HDR=Yes";Data Source={0};",
Data Source = "C:\Users\admin\Desktop\Bulk1.xlsx"
Please help !
1 answer
Hi,
I had a similar problem connecting with Microsoft Access 2010. If you're facing the exact same thing (I assume you are), then I think you are running the 64-bit version of Office. In such a case you'll need to debug for 64-bit architecture. As VS by default debug programs in 32-bit architecture.
Regards