Ok, there are the contents of the sample csv file:
#NAMES,,,,,,,,,,,,
OMSID,WCID,FilePath,POI,POIType,Critical,SortOrder,EffStartDate,EffEndDate,ChangeBy,ChangeDate,Found,FileFound
#TYPES,,,,,,,,,,,,
I,I,str,str,str,B,I,date,date,str,date,B,B
#ROWS,1,,,,,,,,,,,
5,2,//fhxnas01/pcshare/aseeder/1870_WPLANNER_OMS/1761-16-1.jpg,"""1890c""",Model,1,1,2/12/2014 0:00,12/31/9999 0:00,jb20449,2/20/2014 14:44,0,0
3,2,//fhxnas01/pcshare/aseeder/1870_WPLANNER_OMS/1759-11-1.jpg,977ZH,Base Machine,1,2,2/5/2014 0:00,12/31/9999 0:00,jb20449,2/17/2014 13:25,0,0
4,2,//fhxnas01/pcshare/aseeder/1870_WPLANNER_OMS/1817-12-1.jpg,*,,1,3,2/6/2014 0:00,12/31/9999 0:00,jb20449,2/12/2014 13:47,0,0
This is the output from the script modified by Adam, and using the sample:
INSERT INTO table (OMSID,WCID,FilePath,POI,POIType,Critical,SortOrder,EffStartDate,EffEndDate,ChangeBy,ChangeDate,Found,FileFound) VALUES ('5','2','//fhxnas01/pcshare/aseeder/1870_WPLANNER_OMS/1761-16-1.jpg','1890c','Model','1','1','2/12/2014 0:00','12/31/9999 0:00','jb20449','2/20/2014 14:44','0','0'),('3','2','//fhxnas01/pcshare/aseeder/1870_WPLANNER_OMS/1759-11-1.jpg','977ZH','Base Machine','1','2','2/5/2014 0:00','12/31/9999 0:00','jb20449','2/17/2014 13:25','0','0'),('4','2','//fhxnas01/pcshare/aseeder/1870_WPLANNER_OMS/1817-12-1.jpg','*','','1','3','2/6/2014 0:00','12/31/9999 0:00','jb20449','2/12/2014 13:47','0','0')
This may sound silly, but are there any rows after the #ROWS delimiter in the csv file?