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?
Solved! Go to 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.
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.
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.
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.
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:
User | Count |
---|---|
87 | |
38 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
50 | |
48 | |
35 | |
25 |