SS&C Blue Prism Community

Hi all, I am using Excel as a database and have a complex query to fetch some data. Can I use sub-query or nested query to fetch the data? Does sub-query work with OLEDB connection to Excel?

Hi, I am trying to read data from an excel file using OLEDB connection. My query is fetching the data, but the problem is that it is guessing the datatype of the column on the basis of the content of the data. For example, I have a column named PinC...