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

    Smile Unanswered: Edi text to Access

    Hi
    i am trying to import data from a text file which is in a EDI format. i don't know how to get just the data !!! can anyone help me

  2. #2
    Join Date
    Dec 2003
    Location
    Colorado
    Posts
    24
    intFileNumber = FreeFile
    Open (strPath & strFilename) For Input As #intFileNumber
    Do Until EOF(intFileNumber)
    Line Input #intFileNumber, strCurrentRecord
    'Parse record

    'Update records table
    With rstRecords
    .AddNew
    ...
    .Update
    End With
    End If
    Loop 'Do Until EOF(intFileNumber)
    Ray Burrows

  3. #3
    Join Date
    Nov 2004
    Location
    Missouri
    Posts
    7

    edi format

    go to file - get external data -import

Posting Permissions

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