I'm importing a CSV with builk insert and double quote around the text fields and it is including the ["]'s as a part of my data. How do I fix this?

>>Does anyone know the SQL (or T-SQL) syntax for importing a comma-delimited (or CSV) file into a table?
>
>Hi Alan,
>
>You can use DTS, BULK INSERT command or command-line utility BCP.