In reply to Amy.

Hi Amy, you cannot change the data "on the way in" -- it's going to require post-processing, especially with mixed types like this. Possibly you could use CSV as an intermediary.