Query Excel File Using SQL (OLEDB Object)
Have connected using OLEDB to an excel file with many worksheets. Is it possible to use INNER JOIN to combine these and output the result as a collection in blue prism? This isn't working: "SELECT * FROM [Report$] INNER JOIN [OOH$] ON [MPRN]=[MeterP...