Power Platform Community Forum Thread Details

What I am doing is to run SQL query on Excel file directly. However, the problem is that there are more than 20 excel.csv files in the Sharepoint folder, and whenever I connect sql to each of the Excel files, I need to open up the excel file in advance, otherwise the connection fails.

But opening each of the excel file before I connect sql and run the query and close takes too much time...

Does anyone know how to connect csv file with sql without opening the csv file?

Thanks in advance!

Categories:

Power Automate Desktop