Toad World® Forums

import table data from excel, excel order not getting in toad

import table data from excel, excel order not getting in toad

if we want same excel order need in toad what to do?

Hi om123,

How is your data ordered in Excel? You should be able to use the ORDER BY clause to sort the data after you load it into Oracle.

what if i want the order of records to be the same as what the spreadsheet is. The spreadsheet has mixed blocks of sequences like 1-100 900-1000 200-300. I want the same order in Oracle as the sheet as the order of processing is critical. My sledghammer approach is to create another sequence 1-??? as another column and order by in a temp table.