all rows are inserting but for instance row 2 is finding the comma after sun microsystems, then putting inc in the next column alongsame for row 6 with adobe onesrow 5 is still inserting which is similar two the other rows but i think it is doing the same because of the the double quotesalso the last row is showing no value so is there anyway to put some wording into the row if it is empty say something like 'Empty Value'

I’ve run out of disk space on the dedicated log file drive and need to run a very large query one-off query.The storage administrators have added a temporary extra disk , for the extra sql transaction log file.

Answer: Use the ALTER DATABASE command to add an extra SQL transaction log file with a destination location . The example below adds an extra log file to an existing database

Msg 4861, Level 16, State 1, Line 5Cannot bulk load because the file "c:\users\alynch\Desktop\bulk_insert_BadData.log" could not be opened. Operating system error code 80(failed to retrieve text for this error. Reason: 15105).Msg 4861, Level 16, State 1, Line 5Cannot bulk load because the file "c:\users\alynch\Desktop\bulk_insert_BadData.log.Error.Txt" could not be opened. Operating system error code 80(failed to retrieve text for this error. Reason: 15105).

also the fields with the " and the extra comms are inserting into the database and not showing up in the Txt file

specific to the issue of extra commas inside cell's data e.g. "un microsystems, inc". Not sure as if there could be any way to avoid this situation but how if you double qoute all problematic strings and then open the CSV file into Excel - save it as .xls and use openRowSet method to read/import data into sql table.