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.


    • Related Articles

    • Microsoft Excel Security Issue Disabling Macros

      Overview of Microsoft Security Issue Earlier in 2022, Microsoft added a security measure to Office applications where it blocks Visual Basic for Applications(VBA) macros by default on any files sent via the internet. You cannot prevent the block from ...

    • Modelling Data using the RESTful ODBC Driver

      To model the table's column-information in the desired way, you need to first generate the schema of your data source. Add the below connection parameter in the DSN Manager of your connection wizard:     Generating Schema Files Under the Connection ...

    • Reducing the size of Microsoft Excel file automatically

      Here is a quick tip on reducing the size of Microsoft Excel file quickly and easily. You may need to reduce it for any number of reasons, and this is a quick way to get that done. Launch Microsoft Excel or the Microsoft Workbook in question Go to ...

    • Create a PivotTable to analyze worksheet data

      Being able to quickly analyze data can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. PivotTables are a great way to summarize, analyze, explore, and present your data, ...

    • Unable to set the Interactive Property of the Application Class

      Issue When running a report, you are running into an error about setting the Interactive Property for the Application Class. Symptoms When running a Report out the following error is received: Unable to set the Interactive property of the Application ...