PREVENT ACCESS FROM SORTING FIELDS DURING EXPORT

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: PREVENT ACCESS FROM SORTING FIELDS DURING EXPORT

  1. #1
    Board Regular
    Join Date
    Apr 2005
    Location
    malaysia
    Posts
    175
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default PREVENT ACCESS FROM SORTING FIELDS DURING EXPORT

     
    Dear All,
    I'm trying to export a huge database from MS Access XP to a tab delimited text file. I've sorted a particular field in the Access database in an ascending order. I would like the tab delimited text file to have the same order. However, during the export process, Access re-sorts all the fields according to a different order.

    How do I prevent Access from re-sorting the fields during the export process?

    Alternatively, I can copy & paste small amounts of data from the Access database to the text file if I have no choice. However, this would take the whole day. I'd prefer a more 'elegant' method

    Do you have any suggestions?

    Thanks a lot

    ROBERT RAM

  2. #2
    MrExcel MVP CT Witter's Avatar
    Join Date
    Jul 2002
    Location
    Columbus, OH
    Posts
    1,208
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Base your export off of a sorted query instead. The data in the table is inheritenly "unsorted".

    HTH,

    CT

  3. #3
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    72,905
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)

    Default

    CT

    Just what I suggested here.
    If posting code please use code tags.

  4. #4
    Board Regular
    Join Date
    Apr 2005
    Location
    malaysia
    Posts
    175
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Yes, it worked. Thanks a lot & have a good day

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com