A couple of problems with Bulk Insert is that one it brings in the double quotes. This can be remedied with an update statement or a format file so that is no problem.

I want to update a value in a table in a SQL Server Db with a value from one of the fields in the text file. I want to do this based on a query using the second field in the text file.