Skip to Content

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

Jul 11, 2017 at 06:37 AM


avatar image
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!

capture.png (11.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Jul 11, 2017 at 08:41 PM

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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?