Parse records from memo field

[detrie]

Access 2003

I have a process which imports a txt file into a memo field of my TBLORIGINAL table
Each file may have one record or it may have multiple records
Every record begins (exactly) with

FRE Order Order RAD ShipDate Customer City State Postal Code

For each record in the memo field, I need to create a new record into my TBLPROCESSED table

This can probably be done while it is importing but I need to keep the original file intact

I suppose I could copy and paste but there must a vba way of doing this

 

[DavidAtWork]

I'm a bit confused, are you saying you are importing the entire contents of the text file into one memo field irrespective of how many records the text file contains? I hope I've misunderstood

David

 

[detrie]

Hi... Yes, the entire contents into one memo field. I may get three or four files per day. Each text file may have one to five records in it

 

[DavidAtWork]

why don't you just import the text file into a temp table then append each record to your TBLPROCESSED table adding a marker field that could be used to identify the original text file source. The temp table would be cleared after each text file has passed.
This way you can set up import specs for the text file and do any transformations with the data if necessary

David