Microsoft Access as a Data Source

[ppurington]

I have a client with a number of Microsoft Access databases.  I've uploaded them to the Lakehouse but cannot use them as data sources in the "Get Data" command. 

If I use a Pipeline, Microsoft Access is not a possible data source.  If I use "Dataflow Gen2" to load the data, I get a "DataSource.NotFound: Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." error--which is an error on the Microsoft servers.  

Any other thoughts on how I can load the Microsoft Access database so the tables can be used in the SQL Endpoint?

Thanks!

[HimanshuS-msft]

Hello @ppurington 
Thanks for using the Fabric community.

I can repro the error but will have to reach out to the internal team to get help on the same , I will update you once I hear back from them .

In the meantime i will suggest to reach out to the Microsoft support team for this issue . 
Thanks
HImanshu