topic Re: Microsoft.Jet.OLEDB.4.0 in Product Forum

Microsoft.Jet.OLEDB.4.0

SemVerhaar — Tue, 22 Aug 2023 11:07:52 GMT

I'm working my way through the Consolidation Exercise for the Blue Prism Foundation Training, and using the Utility-File management Business object to get data from the CSV file. Upon trying to get the CSV Values into a collection, I get the following error when running my process:

"Internal : Could not execute code stage because exception thrown by code stage: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."

I've been looking at forum solutions, but I'm not really getting any further. I was wondering if anyone else has had this problem and how they solved it...

Re: Microsoft.Jet.OLEDB.4.0

effers — Tue, 22 Aug 2023 12:19:45 GMT

Sounds like installing the Microsoft Access Database Engine 2010 Redistributable from https://www.microsoft.com/en-us/download/details.aspx?id=13255 could help. Seems to be a known issue from other contexts of Microsoft.Jet.OLEDB.4.0 not being compatible with 64 bit applications.

Re: Microsoft.Jet.OLEDB.4.0

Babjee24 — Tue, 22 Aug 2023 12:23:34 GMT

Hi Sem,

You need to install both 32 & 64 bit Microsoft Access DB engine on the machine. It's available over here: Microsoft Access Database Engine 2010 Redistributable

Thanks,

Babjee Vangipurapu.

Re: Microsoft.Jet.OLEDB.4.0

SemVerhaar — Tue, 22 Aug 2023 14:55:11 GMT

Hi, @effers , I've downloaded the 2016 Access Database Engine 32bit (2010 will not work on my Windows 11 system), and ran it, which gave me 2 .dll's that I've put in Program Files (x86) and in Program Files > Blue Prism Automate. I'm unfortunately still getting the same error every time.

Re: Microsoft.Jet.OLEDB.4.0

SemVerhaar — Thu, 24 Aug 2023 07:43:59 GMT

@Babjee Vangipurapu, I've downloaded the 2016 Access Database Engine 32bit (2010 will not work on my Windows 11 system), and ran it, which gave me 2 .dll's that I've put in Program Files (x86) and in Program Files > Blue Prism Automate. I'm unfortunately still getting the same error every time.

Re: Microsoft.Jet.OLEDB.4.0

SemVerhaar — Thu, 24 Aug 2023 08:18:36 GMT

Problem has been resolved! I had to get the File Management 64x VBO installed rather than the 32x.

Re: Microsoft.Jet.OLEDB.4.0

balupad14 — Wed, 13 Mar 2024 13:30:23 GMT

Hi Sem Verhaar,

I got the same error. I just changed the provider name to "Microsoft.ACE.OLEDB.12.0".

To Do this.

Open the Utility - File Management in the object studio.

Navigate to page - > Get CSV Text As Collection

Double click the Parse CSV Code stage.

Navigate to Code Tab.

Change the connection like below

Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & Folder & ";Extended Properties=""Text;HDR=" & HDRString & ";FMT=Delimited""")

Press Ok. Save the project .

Thank you

Balamurugan

Re: Microsoft.Jet.OLEDB.4.0

Meghashindhe — Sat, 01 Jun 2024 10:05:01 GMT

Can you please explain the process. It would be great help

Re: Microsoft.Jet.OLEDB.4.0

durugkarr — Wed, 07 Aug 2024 13:21:46 GMT

This worked for me!

Re: Microsoft.Jet.OLEDB.4.0

VH_reply — Mon, 11 Nov 2024 13:52:49 GMT

This worked for me ❤️