I think you are using File/Open to open the file. Have you tried using Data/Import External Data/Import Data (This brings up an popup window for you to choose the delimiter)?

I am not sure I have a clear picture on your data model, but here is my first stab.

CREATE TABLE Product

(

Product varchar(100),

Product_Choice varchar(100)

)

INSERT Product values ('671703420','158779036X')

INSERT Product values...