>>if it's just those two formats then an inbetween table without the tel no to import to first if '|' occurs() in a line however many times is one less than usual.
>
>Thanks Ken but, as the title suggests, I've no way of knowing which columns will be missing next time; they may miss out the 3rd address line, or postcode, or God knows what.
>
>Terry

Is the data you receive a complete update, or additions to your old data?