Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Question Unanswered: create file and batch headers

    i've been asked to create a file to send in ASCII format with file headers/trailers and batch headers/trailers? I'm familiar with access but haven't a clue how to go about this exercise
    any help much appreciated

    regards
    richard

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Look into the openrecordset command and looking to the Open and Close commands for creating the text file.....

    Good Luck

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    thanks

    I probably need to go a step back here.
    I have a sheet that says

    File Header Record

    Name Format length start mandatory
    Record Type Numeric 2 1 Y
    File Identifier alphanumeric 8 3 Y
    Date created alphanumeric 6 11 Y
    Filler alphanumeric 234 17
    Record Length 250

    then there is a Batch Jeader Record (similar as above)

    then a request record, request trailer record, batch trailer record and file trailer record

    are these fields i'm creating? - is the file header 1 record? and what are the start lengths?

    any help much appreciated
    regards

Posting Permissions

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