Table is sorting itself

[mstorer]

I have a table that is created by appending (daily) a flat file from our mainframe. This flat file is given to us in a specific order and this order needs to be maintained. Unfortunately, my Access table seems to want to arrange it to suit its own fancy. There is no filter applied to the table and I have removed any sort (that I can find.) When this didn't work, I ran a Make Table query with the proper sort order and replaced the original table. This worked fine until I applied the indexes I had on the original. After applying the indexes the table rearragned the data. Am I missing something? I didn't think that creating indexes should re-sort the table in datasheet view. Thanks for any insight.

- Matt

 

[jfgambit]

Matt -

Indexing will sort the table..

Is there a unique ID that comes with the file? Somethng that you could use to keep the order of the table. Additionally, if you create a AutoNumber and assign that as the Primary Key (Indexed NO Duplicates) then the file should import in the same order it is in the flat file and the numbers added by Access should stay in the order you need them to be.

 

[mstorer]

Thanks jfgambit,

My original thought was that the index was altering the order of the table, and ultimately causing a problem in my queries (I need to use the LAST record for a few). Upon doing a search of previous posts, I came across this one from the other day:

Show The Thread

I walked away from this understanding that indexing did not affect sort order. This seems to contradict what I've experienced and what you have stated.

In any event, your suggestion for a the auto number should work. Thanks again.

 

[jfgambit]

Welcome...

Good Luck