Import Excel Data to SharePoint

Source

If you want to;

  • Import / migrate an Excel sheet to a SharePoint list
  • Import / migrate an Excel sheet to a SharePoint contacts list
  • Import / migrate an Excel sheet to a SharePoint calendar
  • Import / migrate documents to SharePoint with meta data in Excel
  • Import / migrate files to with meta data sourced from Excel

then you can specify an Excel worksheet source;

Configuration

 

Import OleDb Data to SharePoint

Source

If you wish to;

  • Import / Migrate OleDb data to a SharePoint list
  • Import / Migrate documents to SharePoint where the meta data is accessible via OleDb
  • Bulk create items in SharePoint where the meta data is in OleDB e.g.
    • Folders
    • Document Sets
  • Import / Migrate web pages to SharePoint where the meta data is accessible via OleDb

Then you can specify an OleDb table data source.

Configuration

OleDB Table

You can define a data source as being a table using OLEDbTable.  This also (optionally) allows each row to be updated after import as successful or otherwise along with any Exception data.  This is useful for large imports.

Below the table that we are telling Import for SharePoint to use is a worksheet “Clients” in an excel spreadsheet.

If you want to update the source table with status data.

The table must contain columns ImportKey, ImportStatus, Exception.

ImportKey must be unique.

In the example below only the first 10 rows will be considered for import since only they have the importstatus “Import”.

OleDB Select

You can define a data source as simply the results of a select statement using OLEDbSelect.

 

Further Thoughts

The database behind OleDB source could be;

  • SQL Server
  • Access
  • Excel
  • Oracle
  • Simba
  • Interbase
  • Firebird
  • PostgreSQL
  • MySQL
  • MariaDB
  • SAP ERP
  • MongoDB
  • Azure Table

Import ODBC Data to SharePoint

Source

If you want to;

  • Import / migrate data from an ODBC data source into a SharePoint list.
  • Import / migrate documents / files to SharePoint where the meta data is held in an ODBC data source
  • Import / migrate pages to SharePoint where the web page content is stored in an ODBC data source.
  • Bulk create items in SharePoint from an ODBC data source

Then you can specify an ODBC data source.

Configuration

Further Thoughts

The database behind the ODBC source could be;

  • Oracle
  • FoxPro
  • Visual FoxPro
  • MySQL
  • MongoDB
  • Postgre
  • DataFlex
  • Ingres
  • Progress
  • Sybase
  • IBM DB2
  • Azure Table
  • JDBC
  • Microsoft Dynamics

32 / 64 bit

To use a 32bit ODBC Driver you must be running 32bit Import for SharePoint

To use a 64bit ODBC Driver you must be running 32bit Import for SharePoint

Contact us if you are having problems.