Excel as Database in Automation Anywhere A2019 | Connection string for Excel as Database #25

This video explains How to use Excel as a Database in Automation Anywhere A2019.
If you are working on huge Excel dataset using Excel Package, you might face-
Errors (HResult error, Excel is not responding Error)
Slowness in bot execution
To overcome these issues, we must connect to Excel as a Database while working on huge dataset

=========================================================

Automation Anywhere Tutorial Playlist:

Automation Anywhere A2019 Tutorial Playlist:

UiPath Tutorial Playlist:

JMeter Tutorial Playlist:

Git and GitHub Tutorial Playlist:

[qualityassurancelab]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[ajithcs]

Superb mam..Thanks you for making this video..

[saicharanm]

Hey there, Thanks for the video, Would you share a video for inserting data to excel when we are using Excel as DB

[roopaganesh]

Hi, Can you provide connection string for Access 2016. Current one which you provided in video is not working

[nrcktv]

Hello thanks for the video, our client is not allowing us to download accessdatabase engine because of security concerns can you help me connect excel as a database using other technique so that i can perform CURD operations on it

[Artech.Ranjit]

any suggestion what is wrong with this script: Insert into [SalesOrders$$] (OrderDate, Region,
Rep, Item, Units, Unit, Cost, Total) values ("4/1/22",
"East", "Jitten", "Binder", "60", "4.99", "1299.40")


getting error.

[pradeepdorepalli]

Hi,
What if i don't have a header of a column, but I need to use excel as database instead of excel advance or basic. How can I over come the issue ?

[sumanthbs]

Thank u soo much mam and one more this I want to know that is, how we can move the bot from Dev environment to UAT? I want kw actual process they follow in the projects

[social]

Hello, Im gettting an error when attempting to connect that reads as:"Could not Connect to Database. Cannot update. Database or object is read-only." any advice?

[vennmukhilt]

I am getting an error as "Could not Connect to Database. Provider cannot be found. It may not be properly installed". I was unable to download 2010 of MSAccessDatabase due to already existing 2019 version of 64 bit, does the connection command change for 64 bit.?

[chammycamba]

Hello. Upon running the bot, I encountered this error: Could not Connect to Database. Could not find installable ISAM.

Would you know what's causing the error?

Connection String: Properties="Excel 12.0 Xml;HDR=YES";

[korepukarthik]

Hi How to take inside connection string data? Near 3:15

[divyasri]

Hi Mam, I am getting Syntax error in query expression '%CHNG > 2'. error while running the bot. My query is SELECT * FROM [Sheet1$$] WHERE %CHNG > 2. Please let me know anything need to be checked in excel settings?? I just taken a web table and written in to a excel with headers wanted to filter based on %change value > 2.00

[mohamedyounes]

Hi maam, is there an easy way to insert a huge excel sheet data to database (like microsoft sql) in one single go without using a loop . Because i have like 5000 rows in excel with 50 columns, so i wanna insert them in one action without using the loop, thanks

[pranshuprakash]

Please help with the connection string if using ODBC driver ..

[prasadburambe]

Hi Madam, which certification should I do A11 or A2019? In case A11 is obsolete, doing certification in A11 obsolete too ?

[DurgaPrasad-cnbi]

Can we pass excel session from one atmx to another by opening excel?

[vania]

Hi, can use loop as each row in sql data set

[enefezeta]

Hi! Im getting the following message "Could not find installable ISAM"

[GaoARG]

Thanks for sharing, I did the connection as your video, but i get this error "Could not Connect to Database. Provider cannot be found. It may not be properly installed."