Power Automate Desktop #203 || How to Read Excel Data Using SQL Queries (Excel as database)

#MicrosoftPowerAutomate #MicrosoftPowerAutomateDesktop #Excelasdatabase

▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬

00:00 Intro
00:18 Topic 1: Read Excel File Data Using SQL Queries / SQL Connection (Excel as database)
01:47 OLEDB connection String
02:51 Open SQL connection
03:25 Build Connection String
08:00 Execute SQL Statement
09:11 SQL Queries
10:03 Close SQL Connection
12:12 Run Desktop Flow and Output
14:55 Read data from multiple worksheets Using SQL Queries

🔔 Subscribe to my YouTube channel

▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬

▬▬▬▬▬▬ Connect with me 👋 ▬▬▬▬▬▬
PayPal ►
Join access to perks ►

@Microsoft @Microsoft Power Automate @Microsoft Power Apps

[Ajaysh]

Very informative video and unique too. This is the best tutorial. Thanks for creating it.

[PrathameshArolkar]

Does this work with .xlsx files or does it need to be with an older version of Excel?

[ohkangarootp]

Is it possible to query multiple join?

[arifk]

Great video, is there a way to use multiple excel files instead of one?

[balu]

The query data table extracting all data but its without column names, is there any way to get column names also ?

[sathyashiva]

Hi
I tried the same scenario in my case.
I tried left join in my query. I am getting error like JOIN expression not supported.

[abhimanyujain]

It would be better if you could share excel file also with us so that we can also practice.