Export table to fixed length changes the sort of the table

Hello: I have created a series of queries whose end result is an Access
table in the correct sorting order that I want. The next step is to export
it to a fixed length .txt file. I've got the specs to work and the data is
lining up in the proper columns. The problem is that the sorting of the data
changes upon export. What causes the export processs to change the sort?

--
Thanks from a frustrated accountant

In Access there is no way to guarantee a sort order without using an ORDER
BY clause in your query...despite how it may look when you open the table.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"AccessNewbie" wrote in message
news
Hello: I have created a series of queries whose end result is an Access
table in the correct sorting order that I want. The next step is to
export
it to a fixed length .txt file. I've got the specs to work and the data
is
lining up in the proper columns. The problem is that the sorting of the
data
changes upon export. What causes the export processs to change the sort?

--
Thanks from a frustrated accountant

Kevin3NF wrote:
In Access there is no way to guarantee a sort order without using an ORDER
BY clause in your query...despite how it may look when you open the table.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Therefore, the easy way to do this is to export your Query, not a Table.

I suggest that, for ease of maintenance (depending on how much manual
tweaking you had to do to create the Table that you exported), it would
be wise to set up a grand, unified Query that combines the effects of
all those others that you set up. This may not be practical for you,
but if it is, I think you'll save a lot of effort the next time you have
to do this. And you won't have a redundant Table cluttering up your
database file.

-- Vincent Johns
Please feel free to quote anything I say here.

"AccessNewbie" wrote in message newswww.3nf-inc.com/NewsGroups.htm "AccessNewbie" wrote in message news
Hello: I have created a series of queries whose end result is an Access
table in the correct sorting order that I want. The next step is to
export
it to a fixed length .txt file. I've got the specs to work and the data
is
lining up in the proper columns. The problem is that the sorting of the
data
changes upon export. What causes the export processs to change the sort?

--
Thanks from a frustrated accountant