We're using the excel importer to import some data in our application. It seems that the import is done randomly. Record 1 should always be imported first and then record 2 etc. I checked it by adding a autonumber and debugging and it seems that the importer is not importing from top to bottom. We don't have an column where we can sort on and our client wants the data imported as stated in the excel file. Could someone tell how the excel imported works? We can't add simply one column for the sort order because many other customers are using the same excel template.
Which version of the importer are you using? I believe 1.3 or newer should support the import in the order it was in the Excel file.