Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    export to text (97 sr2)

    I need to export 70 records from a table into individual text files (one text file for each record). Is there a macro or code that can get this done? I am a novice VBA user, so I may need to be walked through it. Thanks...

  2. #2
    dave_hill
    Guest

    Re: export to text (97 sr2)

    The attached file should do the trick.
    It requests the path to export to and the name of the table to export. It can be fancied up, but ought to give you a good start.

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: export to text (97 sr2)

    Dave, thanks for the help. I had no problem changing the little I needed to get the text files looking good. I like simple code that gets the task done, hats off to ya! Dave P,

Posting Permissions

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