Setting up an Excel ODBC (32bit) System DSN

Setting up an Excel ODBC (32bit) System DSN

Issue
You would like to connect to Excel files to use as data in your Intelligence Reports
Resolution
You need to configure a 32bit System DSN on all workstations. Instructions as follows:

Set up a System Data Source Name (DSN) using the Microsoft ODBC Administrator.

  1. Select Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC).

    This opens the ODBC Data Source Administrator dialog box.

  2. Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box.

  3. Select Microsoft Excel Driver as the driver for which you want to set up the data source.

    Click Finish to open the ODBC Microsoft Excel Setup dialog box.

    Description of Figure 5-1 follows

  4. Specify a name for the data source. For example, odbc_excel.

  5. Click Select Workbook to select the Excel file from which you want to extract data.

  6. Verify that the Version field lists the correct version of the source Excel file.