Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    29

    Unanswered: Importing Data with Repeating Header

    Hi all, got a random question about how to import data from a txt file with a repeating header.

    So...lets say you get a report from a mainframe/green screen tool that kicks out a report with multiple pages with repeating headers at the top of each page (see example) but its all in one text file. Is there an easy way to import this to a table in Access?

    Example

    Report 00112 COMPANY PAGE001

    COL1 COL2 COL3 COL4
    as;lkdj sakldjf sadklfj klsdajf
    sdklajf slakdj sladkjf l;askdjf

    Report 00112 COMPANY PAGE002

    COL1 COL2 COL3 COL4
    555 555 5555 5555
    111 2222 33333 4444

    End


    Any Ideas???

  2. #2
    Join Date
    May 2010
    Posts
    601
    Do you want a RND(Answer)?

    I would manually parse the file.

    See:
    Reading text (.txt) files from with Microsoft Access
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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