I have always found it to be easiest to import stuff from whatever file source into a temporary import table that has all the columns defined as varchar(big enough).  import the data into the varchar columns, then look for anything that needs to be fixed up, like removing those tick marks before you numbers.  i'll usually use a series of queries to do this kind of data fixup and looking for invalid values so i can report them.  When the data is clean, then i copy it to the "real" table and convert the data types during the copy.

once the data is in the "real" table you can continue with the rest of the process that works with the information.