Use an Excel file as a data source

Prerequisite : Microsoft Access 2010 Redistributable

Download the 32 bit version : AccessDatabaseEngine.exe

  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:

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.   Make sure that the sheet name ends with a “$” and that it is sorrounded by “[” and “]” characters.

endusersoftware has written 27 articles