Excel as DB provider error

Hi @Srujana OS100222,

I hope you meant Excel as DB. 

You need to have the Microsoft Access Database Engine 2010 Redistributable driver in order to use the Excel as Database. You can download the driver from below link. (I would suggest downloading 32-bit version rather than 64-bit) 
 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

When connecting to the data source, use the Database Connect action and set the Connection mode to Default.

In the connection string field, use the following as a template (enter the full path of your xlsx file as the Data Source parameter)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="full path to your xlsx file goes here";Extended Properties="Excel 12.0 Xml;HDR=YES"
 
Once the connection has been established, use the various database package actions to interact with your data.

Hi @Srujana OS100222 

1. In order to connect to a spreadsheet using the Database package - be sure that you have 32-bit version of the Microsoft Access Database Engine 2010 Redistributable installed.
2. Note that this would also be required for any bot runners that would ultimately be running this bot - something to keep that in mind as you plan for migrations.

Checkout below tutorial to know more,

Dear @Srujana OS100222,

To connect Excel as a database in Automation Anywhere, you will need to have the following drivers installed on your system:

1. Microsoft Access Database Engine: This driver is required to connect to an Excel file and read or write data to it. You can download the Microsoft Access Database Engine from the Microsoft website.

2. ODBC Driver for Excel: This driver allows you to use the Open Database Connectivity (ODBC) API to connect to an Excel file. You can download the ODBC Driver for Excel from the Microsoft website.

3. OLEDB Driver for Excel: This driver allows you to use the Object Linking and Embedding Database (OLEDB) API to connect to an Excel file. You can download the OLEDB Driver for Excel from the Microsoft website.

It is important to note that the Microsoft Access Database Engine, ODBC Driver for Excel, and OLEDB Driver for Excel are all separate drivers and you may need to install all three in order to successfully connect to an Excel file using Automation Anywhere.

Regards,

32 bit version of the driver is no longer available with Microsoft. I’m finding the 64 bit isn’t working. 

Does AA have a solution for this or am I doing something wrong?

 

Hello,

In the DB Connect Activity, select Yes in Use ODBC 64-bit driver for connection and it should work.

Hosni