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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center