Solved: Insert rows into sql from Text file

Anonymous · ‎08-05-2019

Hi,

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

Thanks,

Gopi

ScottShearer · ‎08-05-2019

@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

ScottShearer · ‎08-05-2019

@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

Insert rows into sql from Text file

Helpful resources

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Register for a Free Workshop