Forum Discussion
syed_shadab_mohammed
Jan 15, 2020Copper Contributor
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
4 Replies
- Gunnar Örn HaraldssonCopper ContributorMaybe 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.
- syed_shadab_mohammedCopper Contributor
ok thanks for the reply ill look into it using quick edit Gunnar Örn Haraldsson
- Gunnar Örn HaraldssonCopper Contributor
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.