abianbu28
(Abianbu28)
April 25, 2024, 7:29am
1
Hi,
Can anyone help me to use the excel as Database in UiPath?
ssGbDFB dzsfrBGSVgagvaevga
Thanks in Advance,
Abi
@abianbu28 ,
You can follow this article.
Thanks,
Ashok
Uthraa_S
(Uthraa)
April 25, 2024, 7:32am
3
Hi,
Below thread might help you.
How to connect with Excel as a database ?
Perform the details mentioned in the Step by step guide, for connecting Excel as a database
Open Excel file (Note - Excel file must remain open)
In UiPath Studio Drag and drop Connect / Execute (Non) query activity
Click Configure connection
Open Connection Wizard
Select Microsoft ODBC Data Source
Use Connection String
Click Build
Go to Machine Data Source
Click New
Click Next
Microsoft Excel Driver(.xls)
Next
Finish
Give Some Data Source Name and Desc…
How to use xlslx file as a Database in UiPath and perform SQL queries?
Issue Description: It is required to use an Excel file as a Database in UiPath Studio in order to run queries for our data records.
Assuming there is an *.xlsx file with these records as presented below.
[image]
How to use the above Excel file as a Database in UiPath?
Resolution:
Create a new process with Modern Design Experience enabled.
[image]
In Manage Packages add the UiPath.Database.Activities[1.6.1] depend…
abianbu28
(Abianbu28)
April 25, 2024, 7:45am
4
Hi,
Thanks for the reply!
I have facing the below issue, when i try to assign the excel path,
"Studio closed the active project due to a critical internal error. You may retry to open the project.
Error: UiPath.Studio.Contracts.RecoverableException: Studio closed the active project due to a critical internal error. You may retry to open the project."
Thanks
Abi
Hey @abianbu28 ,
Check my submission for the last beginner challenge series,
The challenge itself was built around using excel as a database.
Hope this sheds some light on the implementation.
Thanks,
Gautham.
@abianbu28 ,
Please share the screenshot exactly on which screen this error occurred.
Thanks,
Ashok
abianbu28
(Abianbu28)
April 25, 2024, 8:45am
7
Please find the screenshot attached,
@ABHIMANYU_THITE1 ,
Would you be able to help @abianbu28
Thanks,
Ashok
1 Like
Uthraa_S
(Uthraa)
April 25, 2024, 1:57pm
9
I think this ongoing issue and am not sure whether its fixed in latest releases. I used to restart the studio whenever i get this (Suggestion to save your work then and there else you might loose your work). After restart it worked for me.
Hi @abianbu28 - You can checkout the below article to use excel as database
HI @abianbu28 - try delete the .local folder from your project and reopen the project.
Hi @abianbu28 ,
Were you able to refer my flow…?