Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed 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?