Excel Automation - Use SQL Queries to read and write to Excel

Do you know that there are more than 1 way to read and write to Excel files? You are probably already very familiar with the actions "Read from Excel worksheet" and "Write to Excel worksheet". But you can also use the following database actions - "Open SQL connection", "Execute SQL statement" and "Close SQL connection" - to read and write to Excel files. The added advantage of using the database actions instead of the Excel actions is that you can read and write much faster. This comes in especially helpful if you have a very large Excel file.

00:00 Introduction
00:13 The scenario

Some of the actions that we will cover in this tutorial include:
00:30 Open SQL connection
02:40 Execute SQL statement
03:25 Close SQL connection

Related videos of concepts used in this video:

Keep in touch!

#rpa #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate #ExcelAutomation

[robertgrzelak]

Any ideas how to connect to Oracle SQL databases?

[suraj_singh]

Hi sir make a videp on run macro code without maintaing macro excel file through powershell script in power automate desktop