Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transfer Text (97/sr2)

    I am trying to export some data using a macro and the transfer text feature. The macro generates a .txt file and is fixed width. When I view the txt file, each row of data is not lined up based on name. This throw off my other program that generates files for our imaging system. Each field must start and stop at the same positions. What am I doing wrong?

    Thanks,
    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Transfer Text (97/sr2)

    Are you using an export spec to define the field widths? If no, that may be the problem.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Warwick, Warwickshire, England
    Posts
    189
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Text (97/sr2)

    I had a user with a similar problem before - it LOOKED as if the data wasn't lined up, but was due to viewing data in WordPad (uses proportional spacing) verse Notepad. Possible?

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Text (97/sr2)

    Yes. I have created the file specifications.

    Any other suggestions?

    DP

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Text (97/sr2)

    Did your macro is something like the attachment ?
    This is working for me.
    Francois

  6. #6
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Text (97/sr2)

    yes.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer Text (97/sr2)

    Can you attach a stripped version of your db so we can have a look at it ?
    Francois

Posting Permissions

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