Order Of Rows And Columns Returned When Reading With Excel ODBC Driver

Hi,



I'm reading values from a named range within an Excel spreadsheet using the Excel ODBC driver. If I ask for all columns within a range, using e.g. select * from 'named range', does the driver ensure that the returned rowset has the same column and row ordering as in the spreadsheet? In other words, if a named range on a spreadsheet is the block of cells:



name age

richard 54

jemima 27



I want to make sure that my returned rowset is not going to be:



age name

jemima 27

richard 54



I know that proper databases do not guarantee the order of returned values (unless you specify it) but since Excel is a fixed view of data I was hoping that a returned rowset of values would retain their spreadsheet ordering.



Thanks,



aionaut