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. This case study shows you how to use an Excel file called employees.xls as a source in Oracle Warehouse Builder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |