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 exactly 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, _
Thanks for such a fast reply. It's deleting the data in an existing table, then importing the data. There is no key, but I'm thinking maybe I need to do that. I just "assumed" without specifying any kind of sort order, the import would import the file exactly as is.