cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Questions
Frequent Visitor

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

1 REPLY 1
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

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (69,743)