When doing an import using multiple sheets from an Excel spreadsheet, the import does not import the records in order. I want the import to start at the first record on the first sheet and go in order through each sheet to the very end. It does not do this. It jumps around at random points. It is not even like it doesn't do the sheets in order. It will stop in the middle of one sheet, go to another sheet and go in order, and then jump to another sheet right in the middle. It happens with all spreadsheets, not just one.
Toad is importing the records from the spreadsheet in the same order they appear. You can confirm this by spooling the import. Oracle makes no guarantee that the records you import will be displayed in the same order that you import them in. In fact they will tell you that the only way to guarantee any kind of order in your dataset is to specify an ‘order by’. So, Toad is importing them in the correct order, it is just the Oracle database that is rearranging them.
