Generate external tables from Spreadsheet(containing multiple worksheets)
642201May 30 2008 — edited Jun 2 2008Hi,
Is it possible to load data from a spread sheet (containing multiple worksheets) to external spreadsheets. Each worksheet needs to be loaded to a separate external table. I have tried loading data to external table using a single worksheet using the below code.
CREATE TABLE EXT_ASSET
(
ASSET_ID NUMBER(9),
ATTRIBUTE_ID NUMBER(9),
START_DATE DATE,
END_DATE DATE,
ATTRIBUTE_VALUE_ID NUMBER(9)
)
ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY rlipper
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE noLOGFILE noBADFILE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
(
ASSET_ID ,
ATTRIBUTE_ID,
START_DATE DATE "mm/dd/yyyy",
END_DATE DATE "mm/dd/yyyy",
ATTRIBUTE_VALUE_ID
)
)
LOCATION ( 'asset.csv' )
)REJECT LIMIT UNLIMITED;
Google searches suggest using Jakarta-POI for the same.I would like to know if it would be possible without using Java environment?
Could you please help me out in this?
Thanks in advance
Ranjana