Storing excel file in databse

Help Studio
1

Hi everyone,

i have a excel file with more than 100,000 lines and i need to handle each row, the problem is that i tried with datatables and looping with the foreach row activity but crashes or taking hours to complete the exec(btw the read range activity works fastly so the problem inside the loop process). In various topics i found that the solution might be in using database so my question is what are the steps to use it?
thanks for the help,

2

Hi,
You will have to use excel as database. To use excel as database you need to have the connection string. You will get your connection string on this webpage Excel connection strings - ConnectionStrings.com.
1.) use connect activity → use the connection string as input
After that use the database commands of uipath get your result.