Looking for some help. Not really sure if this is VBA or Access. I'm
using Access97, and using the TransferText command, and I want the
text file to come into the Access table as is; no sorting. However,
when I open the table, the records aren't in the same order as the
import file. Any suggestions? Here's my syntax: DoCmd.TransferText
acImportFixed, mySpec, _
tableName, myString

Thanks in advance!

Dave

bytedad (AT) ivillage (DOT) com (Binary Dave) wrote in message news:<e7074e57.0307180628.32d806bf (AT) posting (DOT) google.com>...

I created a short text file and imported it into a two different table
using the same syntax for the TransferText command. One table had an
index and the other didn't. The table witbout the index shows the
records in the same order as the file. The table with the index has
the records sorted by xyz. I hope this helps.

-charles-