locked
Error: Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine RRS feed

  • Question

  • User-73514677 posted

    Hi .

    I am trying to connect to excel using OLEDB from a C# code. I have used the connection string as

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path.xlsx;Extended Properties='Excel 12.0 XML;IMEX=1;HDR=YES;TypeGuessRows=0;MAXSCANROWS=0;ImportMixedTypes=Text'

    I am getting error as -  Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

    I am using this in SSIS 2016 - Script task. How to fix this?

    Thanks

    Monday, March 30, 2020 10:51 AM

Answers

All replies