Answered

Get Data from Access Database results in OLEDB 12.0 error

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I'm trying to connect to an Access Database stored in my OneDrive. When i choose the location and click next I get the following error:

An exception occurred: DataSource.NotFound: Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 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. (Session ID: 38ca8398-fc80-4641-bc38-f4a4f828cd43)

I have triple checked to make sure the Database engine is installed (I reinstalled it a couple times just to be sure) but I don't understand how this is relevant as the data is not coming from my machine anyway (OneDrive).

If CDS doesn't like Access Databases from OneDrive is there another, easier way to get that data into CDS?

Thanks

Categories:

Microsoft Dataverse with Power Apps

CDS access db err...

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

I suggest one of these options:

1 Save the tables as Excel, use power query feature to clean them up and import as CDS entities. This will work best if the target entities have the exact name fields as the Excel ones.
2 convert to Sql and use Sql connector
3 convert to SharePoint and use SharePoint connector.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report

Hi @Anonymous ,

Do you want to connect to the Access Database stored in your OneDrive folder from your canvas app?

If you want to connect to the Access Database stored in your OneDrive folder from your canvas app, I afraid that there is no way to achieve your needs in PowerApps currently.

As an alternative solution, I think the "Power Query" functionality in CDS could achieve your needs. You could consider sync data from your Access Database to CDS Entity using Power Query functionality:

Go to your PowerApps Web Portal, select "Entities" option under Data tab, then click "Get Data"-> "Get Data" option to launch Power Query, then select the Access database as above. Then you need to configure the connection to your Access database stored in your OneDrive folder:

More details about Power Query in CDS, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq

Best regards,

Was this reply helpful? Yes No
buddhimaO 2 on at

Like (0)

Report

I'm having this error when trying to upload an excel file that I got from MS learning paths..
"Record","Field","Error"
"","General error","Unable to parse import file 0d49c52fce6e4334ad2b42a996dfc646_crbe6_petsedited.xlsx Error details PQOnline failure - The powerquery job failed with error: Exception ExceptionType:MashupEvaluationException, ExceptionMessage: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 2010 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., EvaluationResponse:{'ResultType':'Exception','Message':'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 2010 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.','Details':[],'Errors':[],'EvaluationUsage':{'HourlyEvaluationCount':1,'DailyEvaluationTime':1132,'HourlyEvaluationCountRemaining':999,'DailyEvaluationTimeRemaining':86398868}}, EvaluationUsage:{'HourlyEvaluationCount':1,'DailyEvaluationTime':1132,'HourlyEvaluationCountRemaining':999,'DailyEvaluationTimeRemaining':86398868}"

The excel file that I was trying to upload is attached below...

crbe6_petsedited....

Was this reply helpful? Yes No