In trying to use a CSV as a Data Source for a Business Process in Laserfiche Cloud on the Integrations > Data Sources > [DATA_SOURCE_NAME] > Edit Data Source page trying to Verify the settings (below) and I am receiving this error message:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I have googled this error and found suggestions to install:
- Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-au/download/details.aspx?id=13255)
Microsoft Access Database Engine 2016 Redistributable (https://www.microsoft.com/en-us/download/details.aspx?id=54920)
Microsoft Data Access Components (MDAC) 2.8 Software Development Kit (https://www.microsoft.com/en-us/download/details.aspx?id=21995)
I have also restarted the computer that has the remote worker set up. I have a SQL data source on that same computer and it works fine so I know the most of the rest of my setup is configured correctly.
My Data Source settings:
Edit Data Soure
Name: CSV Test
Description: This is a test.
Remote Agent: Test Remote Worker
CSV folder path: C:\test\test.csv