Oh, but Steve, you really must experience the joy of trying to import "sometimes-quoted" fields using BULK INSERT!

BULK INSERT Fun_With_Quotes
FROM 'C:\Import\venmo.csv'
WITH ( FORMAT='CSV');