Import issue with irregular text file

[NewtoIT]

Sorry, I posted this in General questions by mistake.I have the below text file sample named NOTE.txt. It seems that the info was entered into a memo field and ctrl + enter has been used. I use pipe delimited with no text qualifier and I cannot get Access to import it correctly. Of course the 3 fields are NOTE_ID, NOTE_IDB and NOTE_TEXT. Line 1001 imports fine. Lines 1002 and 1003 start fine, then mess up. Line 1004 and 1005 import fine. Can anyone help or offer some VBA code to do this import?

NOTE_ID|NOTE_IDB|NOTE_TEXT
1001|1297|STANDING ORDERBEGINNING 5-11-98 ENDING 4-30-99 SHIPPING 1 EVERY 2 WEEKS
1002|1297|STANDING ORDER
BEGINNING 11-11-98
ENDING 11-11-99
SHIPPING;
10CS ITEM 1 WEEKLY
3CS ITEM 2 WEEKLY
3 CS ITEM 3 10% WEEKLY
DELIVER TO John Doe
REF P.O.ABC456


VERN
1003|1297|PRINTERS ARE TO BE USED FOR STAR, CERNER APPOINTMENTS, AND ESI.
NET 30 DAYS. FOB TMC DOCK,
WARRANTY 1 YEAR ONSITE PARTS AND LABOR.
1004|1297|DELIVER TO Janie Doe IN DND OFFICE. THANKS AL
1005|1297|PLEASE DELIVER TO DEPT DEPARTMENT

[June7]

Here is example of code to import a simple text file http://www.bigresource.com/Tracker/Track-vb-zAjbnMPyEv/. Your situation will require testing each line for the pipe character and handling as needed.

[NewtoIT]

Thanks June7 for the help but as my moniker would indicate, I am new to IT stuff like this. I thought it might be an easier answer such as DoCmd.TransferText acImport (and the rest that follows here would be pushing my skills some). I went to that page and I understood the question but got lost once the answers started. Can you give me some starting code using C:\MyFiles\NOTE.txt and the field names of NOTE_ID, NOTE_IDB and NOTE_TEXT (all text fields) and a pipe delimiter?

[June7]

From the sample in your post, each line is not a complete record. The NOTE_TEXT data is continued on multiple lines. This makes the TransferText method unworkable. Also not possible to set a link to the text file. This leaves the VBA code method that opens the text file and reads each line in a loop structure, parses the line on the delimiter (if present) into an array and saves each array item to appropriate field. The complication is concatenating the multiple NOTE_TEXT lines into a single string.

You have code example to model from. Attempt adaptation to your situation and post for analysis.

Here is another thread on topic https://www.accessforums.net/program...ion-23820.html
Post #2 has couple links you might find of interest.