Last rows not imported when using 'Last Row' and 'Use array DML' options of Import Table Data (4310250)

Last rows are not being imported from an Excel file when using the 'Last Row' field and 'Use array DML' option of Database | Import | Import Table Data.

When specifying a 'last row' value and the 'use array DML' box is checked, Toad will load to the lowest multiple of the 'array size' value BELOW that value of the 'last row' field. When leaving 'last row' blank, it loads all rows.

For example, set 'first row' to 2 to skip headers and 'last row' to 45501 (65000 total rows in the spreadsheet), then check 'use array DML' with an array size of 1000. It only loads 45,000 rows instead of 45,500. No errors are logged.

Rows processed: 45500
Rows added: 45000

WORKAROUND

Create a copy of the Excel file with only the rows required for import and use that file. The 'last row' field will, therefore, not need to be populated.

STATUS

This issue is fixed in Toad for Oracle 12.1. This version can be downloaded from the downloads section of our website, which you can access by clicking here.