Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Philadelphia, Pa
    Posts
    3

    Unanswered: Sort problem when importing

    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, _
    tableName, myString

    Thanks in advance!

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Is the specification appending to an existinf table or creating a new one

    did you set a key to any of the fields in the txt file?

  3. #3
    Join Date
    Jul 2003
    Location
    Philadelphia, Pa
    Posts
    3
    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.

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    That table may have been viewed in a sort order at one time and then saved that way

  5. #5
    Join Date
    Jul 2003
    Location
    Philadelphia, Pa
    Posts
    3
    Thx, I'll investigate...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •