Unanswered

Datatable to sql

(0) Share

Report

Posted on by HazemSaleh

hello,
Im ready data from excel as DB, my data table has over 100 column,
added new connection to sql server to insert few column form the data table

Insert into [PayOpsRPA].[InternalAccountNumber] Value select (%QueryResult%['Internal Account Number'])
I always get an error when i try to get this column from the queryreslut.
How i can do this?
Any insert examples?
BR/Hazem

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
The SQL syntax is different

Insert into [PayOpsRPA] ([InternalAccountNumber]) select (%QueryResult%['Internal Account Number'])

Was this reply helpful? Yes No
HazemSaleh 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks i managed it 🙂 row by row

Was this reply helpful? Yes No
kianafdac 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I used that syntax, but I'm getting an error: Incorrect syntax near ','. which is interesting because there is no comma in the statement. Any ideas on how to fix this error?

Was this reply helpful? Yes No
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Check the input for that step in the execution log. Likely you are providing multiple values to the INSERT statement, but that requires a different format.

Was this reply helpful? Yes No