Reading multiple line edi file into one record in Access
Posted on 2012-08-30
I have an edi file that has 3 lines in it
1 sku price
4 item detail shipping price
5 shipping tracking number
How do I link or take this file and have access read then create the record from this file, so that i have one record holding all three lines as one. it is tab del. each file has multiple orders that are coming in on it. and ther is no linking information between the row or I would just create 3 files with each one sorting out of the the lines then tying them together. Any help is much appreciated.