Import Data from SQL Server to SharePoint

Import Data from SQL Server to SharePoint

Overview of Import Options

This page describes how to import data from a SQL Server database through an ODBC connection into a SharePoint List using
List Bulk Import.

Step Action
1. Connect to the Target Site. If you aren’t connected to the desired site, see Reset the Connection to the Target SharePoint Site.
2. sql start2.pngIn the Import Tool section of the dashboard, click Create Import Job.

import from SQL.pngOn the Location of Source Data page, choose SQL Server (ODBC Driver).

ODBC data source configured on my pc.png

When that choice is selected, you will see the Select User Data Source selection list.

Icon-WarningIMPORTANT: The Select User Data Source list will include all the ODBC data sources that are configured with the SQL Server driver on the PC where you are running the List Bulk Import. This import tool doesn’t support other ODBC drivers at this time.

Choose the data source that contains the data you want to import into SharePoint and then click Next.

4. sql.pngOn the Source Information tab of the Specify Source and Target page, select the Table or View that contains the data to be imported.
sql target.png

On the Target Information tab of the Specify Source and Target page, select the SharePoint list or library where you want the data to be imported to.


sql map the columns.pngOn the Map the Columns page, map columns from the SQL Table or View to the columns available in the selected SharePoint list.

NOTE: It isn’t necessary to map all columns. If there is no source or target column for some data, leave the selection set to None.


sql Map Values.pngOn the Map the Values page, map any choice or lookup column values. See How to Map Values to Lookup or Choice Columns for more information.

NOTE: If the list or library columns you are importing to don’t include a lookup or choice column, you may see a page that looks similar to the one shown here.


SQL Check for Dups.pngOn the Check for Duplication page, decide if you want to check for duplicates. see How to Check for Duplicate Records.

Otherwise, don’t bother checking for duplicates; it slows the import.

When ready, click Next to continue.


sql start import.pngOn the Review and Import page, review the import configuration.

If you want to save your configuration parameters in the Import Job Deployment area of the page, please see Save the Import Configuration for more information.

When ready, click Import to start the import.

Icon-Tip If you don’t want to import at this time, save your configuration parameters and schedule the import to run later. See Schedule an Import to Run Unattended.

9. The progress of the import will be displayed on the page. When it completes, you can review the results. See Review the results with the Log Viewer for more information.