Step 4: Create the Heterogeneous Services Initialization File Verify that the Version field lists the correct version of the source Excel file. For example, odbc_excel.Ĭlick Select Workbook to select the Excel file from which you want to extract data. The ODBC Microsoft Setup dialog box is shown in Figure 5-1.įigure 5-1 ODBC Microsoft Excel Setup Dialog Boxĭescription of "Figure 5-1 ODBC Microsoft Excel Setup Dialog Box" Select Microsoft Excel Driver as the driver for which you want to set up the data source.Ĭlick Finish to open the ODBC Microsoft Excel Setup dialog box. Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box. This opens the ODBC Data Source Administrator dialog box. Select Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC). Set up a System Data Source Name (DSN) using the Microsoft ODBC Administrator. Ensure that the column names confirm to the rules for naming columns in the Oracle Database.įrom the Insert menu, select Name and then Define. The range should include the column names and the data. In the employee_details worksheet, highlight the range to query from Oracle. If you want to delimit the data to be imported from the Excel file, then define a name for the range of data being sourced: Step 2: Delimit the Data in the Excel File (Optional)
By default, the ODBC driver for Excel is installed on a Windows system. To read data from Microsoft Excel, you need the ODBC driver for Excel.
#Excel odbc manager how to
This case study shows you how to use an Excel file called employees.xls as a source in Oracle Warehouse Builder.
0 kommentar(er)
