SQL Order By Date Field

[ItsMe]

I need to import some records into a table via SQL. I need to make sure the records are created in order by date. The reasons or crazy, but it has to do with data varification in a later process. I want the PK order to mirror the date field order.

The question is, "Will SQL sort my dates in sequence?" Here is the code I am using.

db.OpenRecordset("SELECT UpdateNew, UserID, TransactionDate " _
                       & "FROM tblFasTrakHistory " _
                       & "WHERE UpdateNew = 0 AND UserID = 0 " _
                       & "ORDER BY TransactionDate;", dbOpenDynaset)

[June7]

Could test by import to a new temporary table.

[ItsMe]

I am lazy.....

Actualy, I shelved this and now I am coming back to it. Don't remeber what I did last and I looked at the table and it has a sort order to it. Can't remove the table sort order.

So I guess I will have to motivate myself and build something out...

[ItsMe]

It seems to be doing fine, grabbing the dates in the order I need. My notes said to revisit the Order By in the SQL. After combing through it, it seems the test data I was importing was imported in small amounts of records. This was causing me to question the order the records were being imported. Looking at the table, it looked like it was not in order.

I'm thinking wine bar and tapas are in order now. This module will go live tomorrow morning.....