2 articles Access / Excel / dBase

Use an Excel file as a data source

Prerequisite : Microsoft Access 2010 Redistributable Link: http://www.microsoft.com/en-us/download/details.aspx?id=13255 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…

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 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…