Using Access databases as an import data source

Prerequisite : 32 bit version of Microsoft Access 2010 Redistributable
Link: http://www.microsoft.com/en-us/download/details.aspx?id=13255

  1. Create an ODBC connection item in the Connection Manager. Click “Options | Connection Manager”.
  2. Click “ODBC Connection” button.
  3. Set the settings a shown in the image below:

Add ODBC Connection

Make sure that the path does not contain double quote characters.

Once the ODBC connection is created, you should be able to use the ODBC connection as a data source.

ODBC Update Pipeliner Data

Query the table(s) that contain the data that needs to be imported to Pipeliner.

ODBC Query SQL Database

endusersoftware has written 27 articles