MS Access database connection

Help Studio
1

Hello!

I’m trying to connect to an MS Access database file from uipath. I have downloaded the Uipath.Database.Activities package.

I have a file in my Documents folder, called tickets.accdb.

I’m just trying to do the connect activity.

What do I need to connect? Do I need to run ODBC Data Source Administrator? What format should the ConnectionString and Provider property be in?

2

Hi @bcm

Look at the below link which may help you for DB connection

Hope this may help you to solve your DB connection query
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

3

Hy @bcm,

I hve worked with this package and the Interface it very straight foward. Just a few clicks and you can connect to your database.

image

image

Click ok and the select your file, thats it!

Could you please try it and let me know if you have any questions.

Regards

1 Like
4

The ConnectionString property:
“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\ben\Documents\sembo.accdb”

ProviderName property:
“System.Data.OleDb”

Output window gives this message when I try to run Connect activity:
Connect: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

1 Like
5

@bcm

Step: 1 : Click on Configure Connection

image

Step: 2: Click on Connection Wizard

image

Step: 3: Click on Microsoft access Database file

image

Step: 4: Provide your Database file name, Credentials and Test Connection
image

You are fine to go

Hope this helps

Thanks

6

image
image1920×1080 160 KB

7

hey, the format of database needs to bee .mdb for your connection.

Please try to save as .mdb your database and try the same connection with Uipath.

2 Likes
8

Test connection works if I save the access database file as of type *.mdb

But by default MS Access wants to save the file as *.accdb

So, what would be required to make this work with *.accdb?

I think this has to do with microsofts different engines for office. I think this is the road to hell.

9

Just try this: https://gallery.uipath.com/packages/BalaReva.Access.Activities

10

Hy @bcm, unfortunattly it is difficul I agree.

I have worked a lot with MS Access connecting with MS Excel, I have always used .mdb and this is the reason why :slight_smile:

Happy Automation

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.