cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Insert rows into sql from Text file

Hi,

 

Is it possible to Insert rows into sql table from Text file?

 

Thanks,

Gopi

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Anonymous 

I do not believe that there is yet an "out of the box" connector that allows you to read in a text file line by line in Flow.  However, there are a number of third party connectors available that can provide that functionality.

 

In addition, here is a link that discuss how to accomplish most of your goal b using the PowerQuery connect.

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

1 REPLY 1
ScottShearer
Super User
Super User

@Anonymous 

I do not believe that there is yet an "out of the box" connector that allows you to read in a text file line by line in Flow.  However, there are a number of third party connectors available that can provide that functionality.

 

In addition, here is a link that discuss how to accomplish most of your goal b using the PowerQuery connect.

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,198)