FPSINPUT.BLD_EXCEL_IMPORT

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_EXCEL_IMPORT

This view returns an Excel formula to insert data from an Excel spreadsheet into an Oracle database table. It also includes a header row. In order to use this, you must have the data in the Excel spreadsheet for all columns in the database table except UPDATED_INST in the same order. Basically if your Excel spreadsheet looks exactly like the table then you can use this to import it. NOTE: This is currently not perfect! It does not properly handle columns which are DATE or TIMESTAMP. It will croak if there are any single tick marks (a.k.a. apostrophes) in any cell in the spreadsheet which you might be able to fix with SUBSTITUTE(SUBSTITUTE(cell, "'", "''"). So if you use this and can improve it with your next use then feel free!