Unanswered

Create table in SQL server DB from a csv using Power Automate Desktop

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Is there a was to directly create a new table in a DB in SQL server from a csv file located at a desktop location using Power Automate Desktop. It would be like importing a flat file in SQL server. I know that we can first create a schema in SQL server DB and then import the data but I am interested to know if there's a way to directly import the csv file without creating the schema first.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Read CSV and insert that data table into sql

Is this you need?

Or please explain your scenario in detail.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

There aren't any pre-built actions or methods readily available in Power Automate Desktop for this task.

However, you can utilize scripting languages such as .NET (C# or VB) to accomplish it.

Alternatively, within Power Automate, you can start by reading the data using the "Read from CSV file" action. After that, as you mentioned(Schema would be created first then insert the values into table), you would need to extract all column details to create an SQL table dynamically. Then, by iterating through the data, you can insert the values into the table.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No