I have SQL database where there is a master table and several child tables. There is a key column (id). What I want is to migrate all these column values from multiple tables to one pre-created SharePoint list.(Many to one)
What would be the best way to achieve this. Note: the list is already created with all the required columns and required forms for data submission.
One plan that I have is to use query in SQL server to union or join the table columns export the data to excel(if possible) and then import the same to SharePoint list by simple copy pasting rows.
Not sure if this is the most feasible solution or not.