Table sort order

[David Widener]

I am writing records to a table through a adodb connection using a string SQL
statement and for some reason the records do not stay in the same order that
they are placed in the table, the table is not Indexed and I cannot get them
to stay in the original order

 

[Brendan Reynolds]

Data in a table is not guaranteed to be in any specific order. (Part of the
definition of a table in relational theory is that it is an unordered set of
rows). If you need the data in a specific order, you need to specify the
required order in the ORDER BY clause when retrieving the data.