Data - OLEDB (Access 365)

Swetha__Devaram — Thu, 16 Jan 2020 00:23:00 GMT

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

RE: Data - OLEDB (Access 365)

Kiran_P — Fri, 09 Apr 2021 10:28:00 GMT

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

topic RE: Data - OLEDB (Access 365) in Product Forum

Data - OLEDB (Access 365)

RE: Data - OLEDB (Access 365)