Query: “Select top 100 [ABC], convert(datetime, [XYZ DATE], 101) from [Report$] where [ACCOUNT] like ‘%1200400%’ or [ACCOUNT] like ‘%1201800%’ or [ACCOUNT] like ‘%1202500%’ or [ACCOUNT] like ‘%1201100%’ or [ACCOUNT] like ‘%1152600%’ or [ACCOUNT] like ‘%1151900%’”
Use the Read Range activity to read the Excel file into a datatable. Execute Query is used for running queries against a database, rather than reading from a file.
Hi, Actually there are over 500,000 records in the excel file. Hence I thought I’d use queries here. Besides, the file is of .xlsb extension.
Will read range activity be efficient here?
Read range will be slow if you have many columns. There is no local solution for this. If you need to speed up reading of the data, I recommend having a process set up agnostic of UiPath which loads the data to an SQL datatable and reading it from there.