TransferSpreadsheet method does not keep field type

[Hawkes]

I am using TransferSpreadsheet to import data from an Excel file. All the
cells in the Excel file have been formatted as text even though some contain
numerical values. The TransferSpreadsheet automatically assumes field types
based on the content of the cell and not the format so I need a way to change
the field type from Number to Text after the transfer/import. Is there an
easy way to do this? Thanks in advance.

 

[Klatuu]

You might try saving your Excel spreadsheet as a .cvs file, then creating an
import spec for it.