Answered

Load data from CSV into SQL server?

Like (0) Share

Report

Posted on 17 Dec 2020 16:02:30 by Community Power Pla...

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?

All responses (2)

Answers (1)

takolota1 4,913 Moderator on 08 May 2022 at 22:17:12

Like (0)

Report

Re: Load data from CSV into SQL server?

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/td-p/1715338
Verified answer

v-litu-msft on 18 Dec 2020 at 03:38:26

Like (0)

Report

Re: Load data from CSV into SQL server?

Hi @Anonymous,

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.com)

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.