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.
<!-- The source used is ODBCSelect meaning that Import for SharePoint expects to run a SQL select statement against an ODBC data source. This will ignore columns like importstatus -->
<!-- So a system DSN has been created called WordPress, this has in fact been pointed to a MySQL database hosting WordPress -->
<!-- The select statement to run to obtain the rows for import. This one actually gets all wordpress blog posts -->
<SelectStatement>select *, concat(post_name,'.aspx') as DestinationFileName, replace(post_content,'\n','<br/>') as PageContent, 'True' as Publish from wp_posts where post_type = 'post' and post_status = 'publish'</SelectStatement>
The database behind the ODBC source could be;
- Visual FoxPro
- IBM DB2
- Azure Table
- 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.