Exporting Tables

[HoneyBrown]

I'm trying to export an access 2000 table to a text file. The table doesn't have a primary key, but one of the fields is indexed (contains duplicates ) and sorted.
For some reason, access ignores the table format and exports it not sorted.

Help please..?

 

[orna]

Build a query, sort it and then export it to a text file.

 

[HoneyBrown]

Thanks a lot orna!
I tried it and it works! Much slower than exporting a table, but works!

 

[The_Doc_Man]

HoneyB, when directly exporting a table, order is determined ONLY by the PK, not by any indexes. Therefore, your observation about export order is quite correct. The table was probably reported in the same order as it was stored, i.e. chronological with respect to data-entry date/time.

The export via query is preferred when trying to establish order other than the PK. Imposing a PK also works.

Note that even if you compress a database, the table won't be re-ordered - because you didn't have a prime key. Tables get physically re-ordered by a Compress operation only in the order of their prime keys. Non-PK indexes need not apply.