Importing a file becomes out of sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am processing MS/Access 2000. Ocassionally when I import a file that has a
sequence numbers in it the (output) file becomes OUT of sequence after the
IMPORT
Any ideas??? Appreciate any feedback
 
Are you talking about the order of records in a table? A relational database
has no order at the table level. A table is just a bucket that holds data.
When you put this data into a query, form, or report, then you can sort on
your sequence number to put the data in the order which you wish to see.

If you are exporting data from a table, export a query instead with the
records sorted first.
 
Eddie said:
Thanks Jerry, When we IMPORT the file and look at it, it's all out of
sequence.
Click to expand...

Did you read the Jerry's response below? You are never guaranteed a
particular order when looking at a table regardless of how that table was
created. Use a query, form, or report with the sorting you want applied to
that container.
 
Back
Top