Load data from CSV into SQL server?

[Questions]

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?

[v-litu-msft · Accepted solution]

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]

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/...