You’re offline. This is a read only version of the page.
112
Hi Experts,
I am using excel as a database using OLE DB API.
ConnectionString: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%ExcelPath%;Extended Properties ="Excel 12.0 Xml;HDR=YES";Persist Security Info=False
I am using left join in my SQL query. I am getting JOIN expression not supported error from Execute SQL Statement while running the flow.
Please help me on this..
Well, it is not supported. It's as simple as that. There are limitations to what you can do while running SQL to Excel, and joins is one of the things that are not supported. Not much you can do about it, other than pushing your data to a different data source.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Share
Report
All responses (
Answers (
