I have used code similar to what follows to import comma, quote delimited text.  The number of rows and columns is usually small. 

bulk insert dbname.dbo.tablename from '\\servername\directoryname\filename.csv'

 with

 (

          DATAFILETYPE      = 'char',

          FIELDTERMINATOR...