Results 1 to 4 of 4

PREVENT ACCESS FROM SORTING FIELDS DURING EXPORT

This is a discussion on PREVENT ACCESS FROM SORTING FIELDS DURING EXPORT within the Microsoft Access forums, part of the Question Forums category; Dear All, I'm trying to export a huge database from MS Access XP to a tab delimited text file. I've ...

  1. #1
    dgr
    dgr is offline
    Board Regular
    Join Date
    Apr 2005
    Location
    malaysia
    Posts
    128

    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

    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
    65,963

    Default

    CT

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

  4. #4
    dgr
    dgr is offline
    Board Regular
    Join Date
    Apr 2005
    Location
    malaysia
    Posts
    128

    Default

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

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