uploading .csv by phpmyadmin

I am having a bit of trouble here.

I need to upload a .csv into may database and I keep getting errors

I mean this is a plain jane .csv

my fields are not enclosed by anything yet it keeps wanting something there.

Shape,Carat,Color,Clarity,Cert,Depth,Table,Girdle,Culet,Polish,Sym,Fluor,Meas,Comment,Image,, Make,Date,City,State,Country,,Lot #,Owner,Price,%/Rap,Cert #,Stock #
B,1.46,D,SI2,EGL,62.2,55,STK-,N,VG,EX,N,7.23x7.28x4.51,EXCELLENT IDEAL CUT,,,,5/14/2007 14:17,NEW YORK,NY,USA,,11890768,1001dj,3540,-0.4,,1862
E,1.2,H,VS2,GIA,64.2,65,M-,N,VG,VG,N,7.95x5.03x3.23,,,,,5/14/2007 14:17,NEW YORK,NY,USA,,11890770,1001dj,3250,-0.35,,1857
B,0.9,G,SI1,EGL,62.4,56,STK-,N,VG,VG,,6.04x6.12x3.80,TOLKOWSKY IDEAL CUT,,,,5/14/2007 14:17,NEW YORK,NY,USA,,11838062,1001dj,2808,-0.46,,1854

Code (markup):

Here are my frist two rows of my csv

what do i need to enter into my import function to get this to work

I have already entered all the columns names......is this correct?

thanks

 

to put single or double quotes around your data before you insert them.

 

that worked great thanks!

keep getting an error half way through that says something about not valid csv but it is....wierd

 

ok, it's possible to have also ' between two commas, so:
,some ' text, you should make it like this: ,'some\'text', -> escape also ' from text.