I’ve got a very simple BOT I started testing with:
Each time it fails on step 2 saying “Zulu Platform x64 Architecture has stopped working”. There are 32,000 rows in the excel sheet. I’ve also tried just grabbing 5000 rows but same error.
I’ve done this before in other BOTs so I don’t know what the deal is here. Any help would be appreciated.
Best answer by Padmakumar
Hi
Since you are dealing with such a huge Excel file here, I would suggest using either the Data Table or the Database packages to work with this sheet. The execution will be much faster, and I hope you will not face this error as well.
If you are using the Database package for the first time, few things have to be taken care first.
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.
+9Try to identify if you have some special characters in the data, i.e. “\”, “|”, or single quote.
Regards.
+17Hi
Can you share your current Specs of your VM where you are running this bot?
+15Hi
Since you are dealing with such a huge Excel file here, I would suggest using either the Data Table or the Database packages to work with this sheet. The execution will be much faster, and I hope you will not face this error as well.
If you are using the Database package for the first time, few things have to be taken care first.
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
VM Specs looks good, I'd recommend using Excel as a Database approach for this. Checkout below tutorial and try to give a try.
Note: Check whether you are using latest Database package, if not update it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
