How to insert data into SQL DB from the excel file stored in AZURE File storage using MS Flows?

Like (0) Share

Report

Posted on 6 Aug 2019 10:40:01 by chaitanyang

Hi Team,

Can any one please let me know how can i insert excel file data which is stored in AZURE File storage into SQL Db using Microsft FLows?
To explain my query bit more:
1. I have a excel file(.xlsx) format stored in the AZURE FIle storage

2. I want to read this file and store the data into the SQL DB

How to do the second step using MS Flow?

Is it possible or is it a wrong expectation? If it is possible, can you please let me know in a detailed guide manner how to achieve this in MS flow as iam fairly new to it?

Thanks in Advance

Regards

-Chaitanya

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

v-alzhan-msft on 07 Aug 2019 at 07:01:05

Like (0)

Report

Re: How to insert data into SQL DB from the excel file stored in AZURE File storage using MS Flows?

Hi @chaitanyang ,

Have you take a try to create a flow for the steps to achieve your needs?

Could you please takr a try with the "Execute stored procedure" action?

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No