Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Export (Office XP)

    Hi,

    I have a tbale that I need to export as a .txt file. I am using transfer text within a macro to export the data to my desktop. This works OK, but I need to export the data in csv format without the "" marks defining each record

    Example : "850118","5555",1,"2591" needs to be 850118, 5555,1,2591

    Any ideas?

    Thanks....Peter

  2. #2
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Export (Office XP)

    Try using a fixed width export instead of the delimited. Go through the export manually so you can see where it is done. Save the export specification so you can repeat the export correctly each time. in the macro property there is a specification name.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Export (Office XP)

    Fantastic, works a treat. Thanks!

Posting Permissions

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