Excel as Database in Automation Anywhere A2019 | Connection string for Excel as Database #25
Автор: QA Automation Lab
Загружено: 2020-09-01
Просмотров: 35080
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
Download and Install Microsoft Access Database Engine - https://www.microsoft.com/en-us/downl...
Connection String - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path\to\your\excelFile.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";
=========================================================
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A11 Tutorial
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qaautomationlab1
Linkedin - / quality-assurance-lab-6500a71a0
Facebook - / quality-assurance-lab-107065690712674
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qaautomationlab1
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![Creating a Database in Excel [Excel is a Database]](https://imager.clipsaver.ru/1lmtKMG1so8/max.jpg)
