Hello everyone,
I am facing issue to load data from xlsx file to the database table.
Is there any approch to load data from xlsx to table?
please note : I have spreadsheet (xlsx file) which has multiple tabs like (sheet1, sheet2 , sheet3).
here is the code which is being used :-
----------------------------------------------------------------------
OPTIONS (SKIP=1)
LOAD DATA
--INFILE ${FILENAME}
--${LOADTYPE}
INFILE 'E:\queries\sqlldr\csv\Attribute Changes.csv'
INSERT
INTO TABLE CM_TABLE_REF_TEST
FIELDS TERMINATED BY " "
TRAILING NULLCOLS
(
Table_Name,
Attribute_Name,
Business_description
)
-----------------------------------------------------------------------
this is the excel file which need to be load into table.
Any help would be appriciable.
thank you