Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Red face Unanswered: Export Text file without Carriage Return

    Hello,

    I have an Access Database with 3 Tables (Header, Content, & Trailer). The header table has 10 fields, the content table has 15 fields, and the trailer table has 10 fields. Both the header and trailer will only have 1 record each. The content table will have 15k records.

    The manual way of doing it is to export each table independently, then merging the three files, and finally running an external utility to remove the carriage returns and line feeds.

    Is there a way to export all three tables with no carriage returns and/or line feeds into a single text file (fixed length)?

    Thanks,

    Al

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Yes
    Marshall your data then write to the file directly in a vba procedure
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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