Split a field (1 Viewer)

[gerrywiles]

I have a table which is populated from a text file. Within my table I have three fields for the street address, Add1,Add2, Add3. The text file using " as delimiters so I have no issues in populating the Access table from this however the text file only has one field for the street address and this can have more than one line of the address but separated by a comma EG "Flat 4, 141 Commerce Street " or " Flat 4, Goodhall Gardens, 141 Commerce Street"
I need somehow to check this field, update my table field Add1 with anything before the first comma, update the field Add2 with any text between the first and second (if there is a second) comma and update the field Add3 with any text after the second comma.
At the moment I populate the field Add1 with all of the text field and I am now trying to break it down (if commas are contained) to update all three address fields
Any ideas please ?

 

[JHB]

You can use a recordset and the Split function.