Divide one field (column) into 2 or more in Microsoft Access.

A wizard guides you through the process of selecting a field (and table) to be split.

The values found in the field will be split by a delimiting (dividing) character of your choice.

The necessary amount of new fields will be created with the new split-data.