cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Questions
Helper I
Helper I

Load data from CSV into SQL server?

Is there a way to take a CSV file and load it into SQL Server?

I want to grab a file in an email attachment and load it into SQL.

The file could also be in a SPO document library.

I'd want to do this as cleanly as possible, do those connectors exist?  I didn't see them last time I looked but maybe I just missed them?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @Questions,

 

It is possible, you could use Data operation and expression to process the CSV file, or use third-part connector (Such as Encodian) to convert the CSV to an object, then insert these items in the object into SQL via SQL connector.

Solved: Read csv file from email attachment and insert/upd... - Power Platform Community (microsoft....

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

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @Questions,

 

It is possible, you could use Data operation and expression to process the CSV file, or use third-part connector (Such as Encodian) to convert the CSV to an object, then insert these items in the object into SQL via SQL connector.

Solved: Read csv file from email attachment and insert/upd... - Power Platform Community (microsoft....

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

takolota
Super User
Super User

If anyone wants a comma delimited CSV reader / parser using only the standard actions in Power Automate that can also handle larger files, in-data commas, and in-data line-breaks, then try this template flow:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

 

You could also try this batch SQL template to more efficiently enter the values in SQL:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/...

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,646)