Forum Discussion

ppurington's avatar
ppurington
Regular Visitor
3 years ago

Microsoft Access as a Data Source

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!

data engineering

1 Reply

  • HimanshuS-msft's avatar
    HimanshuS-msft
    Microsoft Employee
    3 years ago

    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