Export Forms Data Results to SQL

%3CLINGO-SUB%20id%3D%22lingo-sub-180896%22%20slang%3D%22en-US%22%3EExport%20Forms%20Data%20Results%20to%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180896%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20simple%20survey%20in%20Forms%20and%20then%20export%20that%20data%20to%20SQL.%26nbsp%3B%20Can%20anyone%20assist%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKari%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-180896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-181437%22%20slang%3D%22en-US%22%3ERE%3A%20Export%20Forms%20Data%20Results%20to%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-181437%22%20slang%3D%22en-US%22%3EHi%20Kari%20I'm%20not%20aware%20of%20any%20way%20to%20do%20that%20short%20of%20exporting%20the%20results%20to%20Excel%2C%20saving%20it%20into%20a%20suitable%20format%20(e.g.%20CSV)%2C%20manipulating%20the%20columns%20to%20suit%20your%20SQL%20DB%20and%20then%20uploading%20it.%20Unless%20someone%20else%20here%20can%20think%20of%20a%20better%20way%3F%20Good%20luck!%20Cheers%20Damien%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712723%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Forms%20Data%20Results%20to%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712723%22%20slang%3D%22en-US%22%3EHi%20Karl%2C%3CBR%20%2F%3E%3CBR%20%2F%3EDid%20you%20find%20a%20solution%20to%20this%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3ERuedi%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715344%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Forms%20Data%20Results%20to%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F136333%22%20target%3D%22_blank%22%3E%40Kari%20Giles%3C%2FA%3E%26nbsp%3B%2C%20you%20can%20do%20it%20with%20Flow.%20When%20a%20new%20response%20is%20submitted%2C%20get%20items%2C%20insert%20row%20(SQL%20Server)%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hello,

 

I would like to create a simple survey in Forms and then export that data to SQL.  Can anyone assist please?

 

Thanks,

 

Kari

3 Replies
Hi Kari I'm not aware of any way to do that short of exporting the results to Excel, saving it into a suitable format (e.g. CSV), manipulating the columns to suit your SQL DB and then uploading it. Unless someone else here can think of a better way? Good luck! Cheers Damien
Hi Karl,

Did you find a solution to this problem?

Ruedi

@Kari Giles , you can do it with Flow. When a new response is submitted, get items, insert row (SQL Server)

Rob
Los Gallardos