How to extact information in a bar seperated list and paste the individual items into a field

[B@Th*nG]

Hi guys,

i've got a big bar seperated list, eg:

PK001|PK002|PK003|PK004|PK005|PK006|PK007|PK008|PK009|PK010|PK011|PK012|PK013|PK014|PK015|PK016|PK017|PK018|PK019|PK020|PK021|PK022|PK023|PK024|PK025|PK026|PK027|PK028|PK029|PK030|PK031|PK032|PK033|PK034|PK035|PK036

I want to extract the bits between the bar's and paste into a field in SQL server\Access, IE:

FIELD1
PK001
PK002
PK003
PK004
etc..

Any ideas?

B@