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