Import files out of order

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

Guest

I'm running a macro that imports text files into a table. I do a "delete"
query on the table to clear the contents and then I start import text file1,
text file2, etc...

The problem I have is that sometimes the text files are not in the table in
the I imported them. Sometimes text file3 is before text file2 even though
my macro has the import of text file2 before text file3.

Any ideas - apprciated.
 
Queryman,

Data in a table has no inherent order whatsoever. The only way to
control the order of data is with a query, Queryman. If you want the
order to be based on the file the data was imported from, you will need
to include a field with a reference to the text file in the table you
are importing into, and use this in your sorting.
 
Back
Top