Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    Unanswered: Blank line found when Export Data to txt file

    I'm using Access report to export data to .txt file to make 80 columns Data to process it in Mainfram. but there blank line between data rows found. how I can solve this problim.

  2. #2
    Join Date
    Jul 2004
    Southampton, UK

    How are you exporting exactly ? Using reports to export data is probably a bit messy. You'll get all sorts of things appearing like formatting and page breaks.

    The TransferText action is designed specifically to generate txt files and allows you to be quite rigorous about the column structure. You can use this in either a macro or VBA. If you are not familiar with either then go for a macro. It's dead easy and pretty much self explantory.


Posting Permissions

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