Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Output Methods (Access2002)

    I need to create standardized text files as output to other applications. Can anyone point me to a resource to learn more about how to achieve this?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Methods (Access2002)

    Sure, I do this all the time. You'll want to look up something the Print # statement (in Access help):

    Open strFileName For Output As hFile
    Print #hFile, strHeader
    Print #hFile, strTitle
    Print #hFile, strTOC
    Print #hFile, strText
    Print #hFile, strFooter
    Close #hFile

    There's also the TransferText methods.

    Good luck!

    Cecilia :-)

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Output Methods (Access2002)

    The transfer text method is good as it will create a text file in.csv format to import to other apps. Other methods work well too.

    HTH
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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