Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate external tables from Spreadsheet(containing multiple worksheets)

642201May 30 2008 — edited Jun 2 2008
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2008
Added on May 30 2008
2 comments
495 views