Winshuttle Support systems have migrated into Precisely systems. If you weren't automatically forwarded to the new system, please go to https://support.precisely.com to access Suppport.

Articles in this section

See more

How to export SharePoint Lists data to SQL Database?

Avatar
Fabian
  • Updated
Follow

Description

How to export SharePoint Lists data to SQL Database?

Applies To

SharePoint, SQL

Solution

Follow the steps mentioned below by navigating to the SharePoint List:
  1. List Actions > Export to SpreadSheet/Excel.
  2. Save the Excel file.
  3. Open your SQL database with SQL Management Studio.
  4. Right click on your database > Tasks > Import Data.
  5. Select your Excel file as the source, and specific table as destination.
  6. Fill all other needed options.
  7. Click finish.
This should load the Excel data (original, list data) to the SQL table.

Related articles

Comments

0 comments

Please sign in to leave a comment.

# Notification banner writer