'カンマ区切りの場合

商品番号,商品名,単価,数量,日付
003,みかん,30,8,2008/5/12
001,りんご,100,5,2008/5/12
005,すいか,500,1,2008/5/12
002,ばなな,50,10,2008/5/12
003,みかん,30,12,2008/5/12
001,りんご,100,3,2008/5/12
004,なし,150,4,2008/5/12
002,ばなな,50,15,2008/5/12
004,なし,150,3,2008/5/12
005,すいか,500,2,2008/5/12


'カンマ区切りでデータが、引用符「ダブルクォーテーション」で囲まれている場合。

"商品番号","商品名","単価","数量","日付"
"003","みかん","30","8","2008/5/12"
"001","りんご","100","5","2008/5/12"
"005","すいか","500","1","2008/5/12"
"002","ばなな","50","10","2008/5/12"
"003","みかん","30","12","2008/5/12"
"001","りんご","100","3","2008/5/12"
"004","なし","150","4","2008/5/12"
"002","ばなな","50","15","2008/5/12"
"004","なし","150","3","2008/5/12"
"005","すいか","500","2","2008/5/12"


'カンマ区切りでデータが引用符「シングルクォーテーション」で囲まれている場合。

'商品番号','商品名','単価','数量','日付'
'003','みかん','30','8','2008/5/12'
'001','りんご','100','5','2008/5/12'
'005','すいか','500','1','2008/5/12'
'002','ばなな','50','10','2008/5/12'
'003','みかん','30','12','2008/5/12'
'001','りんご','100','3','2008/5/12'
'004','なし','150','4','2008/5/12'
'002','ばなな','50','15','2008/5/12'
'004','なし','150','3','2008/5/12'
'005','すいか','500','2','2008/5/12'