The only way that sorting should have any affect on the exported data other than the order of the rows of data produced is if you are using an export method that allows you to specify the "group by" option. Have you specified that option?
Is it at all possible that some of your records have an empty ID field? If you enter find mode, specify an = sign in the ID field and perform a find, what results do you get?
Are all the fields shown from the same table or do some come from a related table?
Well once again you are spot on Phil,
I went back in and the data was grouped, but I don't remember doing it, but removing the grouping restored the data in all the fields.
Thanx again for your insights