How to export SharePoint Lists data to SQL Database?
Follow the steps mentioned below by navigating to the SharePoint List:
List Actions > Export to SpreadSheet/Excel.
Save the Excel file.
Open your SQL database with SQL Management Studio.
Right click on your database > Tasks > Import Data.
Select your Excel file as the source, and specific table as destination.
Fill all other needed options.
This should load the Excel data (original, list data) to the SQL table.
Please sign in to leave a comment.