Excel as Data Source in BODS, didn't load all rows in table

[Former Member]

Hi All,

I am using BODS 4.2 version to load one Excel file into Sybase table.

But, after seeing Sybase , Table doesn't have DATA after row # 718. Excel has total rows of 728 with DATA in all row. And I set skip first 6 rows to skip table titles. There should be 721 rows in the table. I don't know the last 3 records are missing.

Does anyone know that, IS THERE ANY LIMITATION excel has on number of rows as source?

Please Help!

[former_member187605]

There's no such limitation.

Start with switching on error logging. There may be formatting errors in the sheet, DS simply ignores those rows when using default settings.

[Former Member]

Thanks for your answer.

But once I set skip first 6 rows, the BODS won't load all records. The missing lines are consecutive and are in groups of 6 (the number I set to skip first).

It's so strange. Is it caused by pageable cache?