One of the denizens of this forum has a wonderful quote in his signature line that states something like "In theory, practice and theory are the same. In practice, they are not". 😀
Neither BCP nor BULK INSERT are designed to handle CSV files and MS states that in BOL. And, yet, for a well formatted file as you have mentioned, both are remarkable in what they can do especially when you get what is known as a "BCP FORMAT FILE" involved, which is the hardcoded method for mapping the file to the table as you might in SSIS. Even without that (someone might not allow you to store a BCP FORMAT FILE although such a restriction would be a matter of preference rather than a practicality), some rather simple things can be done without it.
Rather than provide you with a generic example of what to do and then let you possibly struggle to "get it right", if you could provide me with the "Record Layout" for the file and the "CREATE TABLE" statement for the target table, I'd be happy to provide you with some tested code along with an explanation of what it all is and how it works (and, although it's not a click'n'drag GUI, it's simple). If that's not a possibility, then check out the following links.
I've not included links for either BCP (I suspect that you don't want to do any of this using the command prompt or the command shell) or the XML style of BCP FORMAT FILES because I've found them to be unnecessary complex and require you to do double-identification that's unnecessary in the non-xml format styles.
Also, if you CAN use a BCP Format File, then use the tried and true but undocumented backslash double-quote character combination to use the double quotes as a part of the field terminators. You have to do a special trick with the first quote of each line to get the system to ignore it by counting it as a field in the file that has no target column in the table.
All of this is incredibly easy to do when you know how and usually difficult for most folks that haven't done it before, which is why my offer of tested code help was originally made and still stands. I just need the information that I requested to give 'er a start.