csv input error check

i have a a .csv file that i read into my database, i can read it in fine but if there is a comma that should be in the line it halts the input.

Is there any way i can make a error check so that it a user could edit the input line ,so if it has an extra comma in the line they could remove it and save it back to the .csv file and retry loading the csv file?

Quick answer; probably not w/o a boat load of work.

However I would suggest trying to catch the comma on input into the csv file.

i have trapped the error with on error so ill then delete the database and ask the user to edit the file and display the the line in the csv file which is corrupt. Does this seem like a good way of doing it?