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.	In the Import Tool section of the dashboard, click Create Import Job.
3.	On the Location of Source Data page, choose SQL Server (ODBC Driver). When that choice is selected, you will see the Select User Data Source selection list. IMPORTANT: 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.	On the Source Information tab of the Specify Source and Target page, select the Table or View that contains the data to be imported. 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.
5.	On 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.
6.	On 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.
7.	On 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.
8.	On 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. 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.