Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    MT103 files and exporting individual records to text files

    Just throwing this out there before I go and reinvent the wheel.

    Has anyone used access db for generating the source data for an MT103 type file?

    MT103 being a text file for the transfer of data to finance institution (bank).

    The follow up on this would be:
    How to go about outputting individual records produced from a query to individual text files, i.e. query returns 10 records..so I need 10 text files.

    Thanks
    Alan, in hazy but cool cheshire

    (2007 xp sp3)

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I don't know anything about MT103 files, but I attach a little demo that opens a recordset based on a query, then outputs each record as a separate text file.
    This might get you started.
    Attached Files Attached Files
    Regards
    John



  3. The Following User Says Thank You to johnhutchison For This Useful Post:

    ase001 (2012-03-19)

  4. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Many thanks John, great starter to exactly what I need. Really appreciated.
    Alan

Posting Permissions

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