Data - OLEDB (Access 365)

[Swetha__Devaram]

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
------------------------------

[Kiran_P]

Hello Swetha,

Install Microsoft Access Database Engine 2010 14.0.7015.1000 and use the existing connecting string. We have faced the same issue and this helped in resolving it.

------------------------------
Kiran P Associate Consultant
SENIOR ANALYST
Northern Trust
Bangalore
------------------------------