ADODB Connection

Help
, ,
1

Hello!!

I am developing a project which needs to extract information to excel. The idea is use excel as a data base so that we can apply queries to filter information for this reason I have thought of making an adobd connection because it is very useful and i am sure that this connection solve my problems.

However, I looked for a variable type “adobd connection” and It doesn’t exist in uipath in fact there are just oledb and odbc connections.

Someone can tell me, What Can I do to establish the adodb connection?

or give and example of how to make and oledb or odbc conecction withn excel as data base?

2

Hello!

You can use the Database Activities (Connect, Execute Query, Execute NonQuery). All you’ll have to do is to pass the Connection String on “Connect” Activity. (Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx; Extended Properties=“Excel 12.0 Xml;HDR=YES”; )

Hope It Helps :wink:

Regards,

3

Hi my friend, I tried your suggestion but When I run the project an exception message is shown , It tells that the provider is not installed . Do you know the way to install it?

4

You just need to have Microsoft Excel 2007+ installed. Are you trying to connect to a XLSX or XLS file?

5

It is an xlsx file and office is installed in the computer

6

Ok. Try to install Microsoft Access Database Engine (which is necessary to use the ACE.OLEDB Connection).

Let me know if works.

Regards,

7

ole
ole757×344 9.83 KB

even though I installed the engine, the error keeps coming out

8

Try to use “Microsoft.ACE.OLEDB.8.0”. Let me know what happens

9

it shows the same error but the name the provider now tells OLEDB.8.0 =(

10

I’ll search some examples and share with you after the execution of an artifact that I’m running :slight_smile: