Unanswered

Extract excel and save to SQL

(0) Share

Report

Posted on by Bash--

Hi folks!

I want to create a flow for the outlook inbox having attachments( excel files). The flow needs to extract the excel columns and save that to the SQL table (Azure SQL Data warehouse). I can insert data from the existing excel file (in one drive folder) to the SQL table. But not able to create a dynamic flow that will use to read excel columns and insert that into an SQL table.

Kindly suggest some ways to achieve that.

Thanks in Advance!

Categories:

General topics

All responses (3)

Answers (0)

Sort by

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bash-- found a similar thread here, please check this out

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-Import-Excel-Sheet-Data-into-SQL-Server-using-Microsoft/td-p/394547

Hope this helps.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Bash-- 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jinivthakkar. I am looking for mail excel attachement directly into SQL?
jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bash-- I hope you are running the flow with service account, in that case you can first fetch the attachment, store in in onedrive, read the excel and then delete the attachment or keep it.