And, it probably wouldn't hurt to import the data into a temporary file first, then run a table update query to copy/convert the data to appropriate types in the target table.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert