Sort Order on DoCmd.TransferSpreadsheet

[Helen]

I am using a module to import 120 spreadsheets (1
worksheet for each spreadhseet) from Excel 97 into Access
97. The sort order is important to me.

Randomly I am getting the rows imported into access in a
different order to what I am viewing them in excel.

I am using loops to use the same import code which is
below:

DoCmd.TransferSpreadsheet transfertype:=acImport, _
tablename:="English", _
Filename:=strNetworkName(i),
Hasfieldnames:=True, _
Range:=strRateCard(j), SpreadsheetType:=8

Any ideas on why the sort order goes to something
different to the order that the spreadsheet is held in or
any ways around this?

Thanks