By the way, it seems that you're using INSERT INTO SELECT...FROM OPENROWSET when a BULK INSERT with a proper format file would be more appropriate, unless the double quotes are inconsistent in the same column.

This can give you some orientation about format files: http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/