Issue while reading xls files using Excelworkbook connector in microsoft data fabric

[Anonymous]

Hi everyone

I am trying to upload a excel(.xls) file using the GetData(Excel workbook) connector from a fabric data flow and hitting the following error.

An exception occurred: DataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.

We do have the proper oldeb driver installed and validated the install based on the registry too but still facing the issue. 

Any pointers would be appreciated.

[v-mdharahman]

Hi @Anonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous · Accepted solution]

I could not resolve the issue with converting the xlsx to xls or vice versa. Somehow still hit the same error.

Had to export the file to CSV to make it work. Thanks again for all your respones. Apologies for the delayed response.

[v-mdharahman]

Hi @Anonymous,

If your issue has been resolved then please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Best Regards,
Hammad.
Community Support Team.

[v-mdharahman]

Hi @Anonymous,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-mdharahman]

Hi @Anonymous,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help?

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[v-mdharahman]

Hi @Anonymous,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you're trying to get an excel file in your workspace and there's an error stating that the "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine". Its likely due to OLEDB provider is not installed or properly registered as OLEDB is used to read .xls files but you mentioned you already validated your OLEDB installation and registry but the problem is still there. 
So for this you can reinstall your OLEDB provider or you can cross check if the correct version is registered using CMD or PowerShell because if your environment runs in 64-bit mode then the 32-bit application will not find OLEDB provider.
If the issue still persists then please follow the solution provided by @lbendlin.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[lbendlin]

If possible, convert the xls to xlsx.  Then you can use the native built in drivers.