I have an Access db that has a table imported from an external db (not Access). This table has a free text field with date similar to: BY AIR 01.09.01-3 X APP BY 12.08.01 3 X PRD BY 25.08.01, I need to split this and add the data to another table: "BY AIR 01.09.01" (field1), "3 X APP BY 12.08.01" (field2), "3 X PRD BY 25.08.01" (field3). The word AIR can be replaced by either SEA or CAMION. As the data is entered as free text, there can of course be extra spaces, but the data above will always appear. Is this possible?. I do not have a very good knowledge of vb, sv any answer will need to be quite detailed.
Thanks for your help