web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Perform SQL into data ...

Power Automate

Unanswered

Perform SQL into data table

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi

I need to perform insert [] select from Power Automate data table to Access db. (+1mi rows)

I´ve been trying a lot of SQL syntax, but everything goes wrong.

How can I do It?

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

If you have an issue with SQL syntax as you say then it looks like the connection string does not have a problem.

If not, then correct that first (Access connection strings - ConnectionStrings.com)

If it's a SQL syntax issue then, can you share the syntax and how you are accessing the datatable to see what's going wrong.

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Anonymous
As @VJR said - can you share your code? What exact errors you get and where? Opening connection or executing the query?

Are you able to do simple select like this?
SELECT * FROM [SheetName$]

Also, are you sure you use correct insert statement like one below?
Insert into [SheetName$] ([Column1],[Columns2]) Values ("Data1","Data2")
Remember to close SQL connection to actually save the changes.

Was this reply helpful? Yes No

Join the conversation