Power Platform Community Forum Thread Details

How to connect excel as database in power automate

Hi Narayan,

1. Use built-in Excel actions this this the easiest way

Open your Excel file in Power Automate Desktop and use actions like Read from Excel or Write to Excel. If you format your data as a table, it will work like a simple database.

2. Use SQL connection advanced option

If you want database-like queries, connect Excel using an OLEDB connection and run SQL queries like SELECT * FROM Sheet1. This makes Excel behave more like a database.

Steps:
Use Open SQL connection action
Connection string example:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\YourFile.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;";

Use: Execute SQL statement action

Example query:
SELECT * FROM [Sheet1$]

Reference: https://community.powerplatform.com/forums/thread/details/?threadid=ee69168f-aed8-4725-bd01-865f2cf82e39

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz