Getting an error while trying to read excel sheet in Sequen

shivan · Post by **shivan** » Fri Aug 19, 2005 2:39 pm

I am trying to read excel sheet in Sequentail file and writing it to DB2.
Am getting all the junk data in the view data(Seq file) and also it is showing less no of records.
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 1, column LF_ID, required column missing
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 2, too many columns in record
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 3, column LF_ID, required

Thanks
Shivan

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Aug 19, 2005 2:42 pm

The records are of varying columns.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Aug 19, 2005 2:43 pm

The records are of varying columns.

shivan · Post by **shivan** » Fri Aug 19, 2005 2:45 pm

Can you please elaborate this?

Thanks
Shivan

Sainath.Srinivasan wrote:The records are of varying columns.

chulett · Post by **chulett** » Fri Aug 19, 2005 3:33 pm

You can't use a Sequential File stage to read a spreadsheet unless you've saved it in .csv format first. To read the .xls directly you need to use the ODBC stage instead.

chitra · Post by **chitra** » Mon Aug 22, 2005 4:24 pm

Like Craig said you should convert the excel file to a .csv file and also the no of columns and column length in the sequencial file stage should match the csv file, otherwise you would get the error you mentioned.