Forum Discussion
migrating data from SQL to share point list in share point online
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
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