migrating data from SQL to share point list in share point online

%3CLINGO-SUB%20id%3D%22lingo-sub-1111894%22%20slang%3D%22en-US%22%3Emigrating%20data%20from%20SQL%20to%20share%20point%20list%20in%20share%20point%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1111894%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20new%20to%20share%20point%20%2Ci%20wanted%20to%20know%20how%20to%20migrate%20table%20data%20from%20SQL(SQL%20server)%20to%20share%20point%20lists%26nbsp%3Bin%20share%20point%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%3C%2FP%3E%3CP%3ESyed%20Shadab%20Mohammed%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1111894%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1112239%22%20slang%3D%22en-US%22%3ERE%3A%20migrating%20data%20from%20SQL%20to%20share%20point%20list%20in%20share%20point%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1112239%22%20slang%3D%22en-US%22%3EMaybe%20depending%20on%20the%20data%20and%20amount%20of%20data..%20But%20have%20you%20tried%20to%20create%20the%20list%20with%20same%20columns%20and%20same%20order%20and%20then%20select%20all%20data%20in%20the%20table%20and%20do%20copy%2C%20then%20open%20list%20in%20%22Quick%20edit%22%20mode%20and%20paste%3F%20Have%20not%20tried%20from%20SQL%20but%20it%20does%20work%20with%20excel%20data.%20Else%20I%20guess%20you%20could%20do%20it%20with%20powershell%20or%20make%20some%20console%20program.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1112487%22%20slang%3D%22en-US%22%3ERE%3A%20migrating%20data%20from%20SQL%20to%20share%20point%20list%20in%20share%20point%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1112487%22%20slang%3D%22en-US%22%3E%3CP%3Eok%20thanks%20for%20the%20reply%20ill%20look%20into%20it%20using%20quick%20edit%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F135317%22%20target%3D%22_blank%22%3E%40Gunnar%20%C3%96rn%20Haraldsson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1115209%22%20slang%3D%22en-US%22%3ERE%3A%20migrating%20data%20from%20SQL%20to%20share%20point%20list%20in%20share%20point%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1115209%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F520511%22%20target%3D%22_blank%22%3E%40syed_shadab_mohammed%3C%2FA%3E%26nbsp%3Bok%20super%2C%20hope%20it%20works%20for%20you!%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20how%20it%20works%20out%20in%20your%20case..%3C%2FP%3E%3CP%3EBut%20if%20its%20big%20table%20like%20thousands%20of%20records%20or%20even%20more%20then%20I%20guess%20I%20would%20use%20PowerShell%20or%20write%20C%23%20code%20to%20do%20the%20migration.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1121602%22%20slang%3D%22en-US%22%3ERE%3A%20migrating%20data%20from%20SQL%20to%20share%20point%20list%20in%20share%20point%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121602%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F135317%22%20target%3D%22_blank%22%3E%40Gunnar%20%C3%96rn%20Haraldsson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20a%20method%20using%20which%20we%20can%20setup%20a%20connection%20between%20SharePoint%20list%20and%20SQL%20server%20using%20Microsoft%20access%20and%20i%20am%20able%20to%20migrate%20the%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20and%20regards%2C%3C%2FP%3E%3CP%3ESyed%20Shadab%20Mohammed%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hello everybody,

 

i am new to share point ,i wanted to know how to migrate table data from SQL(SQL server) to share point lists in share point online.

 

thanks 

Syed Shadab Mohammed

4 Replies
Maybe depending on the data and amount of data.. But have you tried to create the list with same columns and same order and then select all data in the table and do copy, then open list in "Quick edit" mode and paste? Have not tried from SQL but it does work with excel data. Else I guess you could do it with powershell or make some console program.

ok thanks for the reply ill look into it using quick edit @Gunnar Örn Haraldsson 

@syed_shadab_mohammed ok super, hope it works for you!

Please let me know how it works out in your case..

But if its big table like thousands of records or even more then I guess I would use PowerShell or write C# code to do the migration.

Hello @Gunnar Örn Haraldsson 

 

I got a method using which we can setup a connection between SharePoint list and SQL server using Microsoft access and i am able to migrate the data

 

thanks and regards,

Syed Shadab Mohammed