Hello,
I am trying to pull data from a built in Query in MS Access, I used "Data - OLEDB" actions (Configure, Open, Get Collection, Close Connection). It was working when we were on Windows 7 operating system and older version of MS Office. We recently switched to Windows 10 and MS Office 365 and it was failing since then. Is there a different Provider String for Access 365?
Or is there any other way I can import data from Queries into Collections? I was using "Microsoft.ACE.OLEDB.12.0" when we were on the older versions.
Please advise.
Any help is greatly appreciated.
------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------
