Insert rows into Access Table in order from c#

I have a sorted list of insert statements that I am trying to write to an Access db. I have triple verified that the list of insert statements is in the correct order. When I open the mdb file the records are never in order. Maybe for the first 100 records, but after that it starts getting out of whack.

I am really at a loss here, any ideas? Note that this table is being created in开发者_Python百科 C# first dynamically - i.e. the set of of columns is not predictable each time this code needs to be run.

Maybe you just need to add an ID field to the tables and then the insertion order should be maintained.

When adding rows to any database, the concept of "Order inside a Table" is meaningless.

You get your order when retrieving records by using an ORDER BY.

Make sure you have an ID or TimeStamp column to sort on.