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

    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
    Location
    Southampton, UK
    Posts
    368
    Hi

    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.

    hth
    Chris

Posting Permissions

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