Prerequisite : Microsoft Access 2010 Redistributable
Download the 32 bit version : AccessDatabaseEngine.exe
- Create an ODBC connection item in the Connection Manager. Click “Options | Connection Manager”.
- Click “ODBC Connection” button.
- 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.
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.