Import from Excel

[JetDave]

I've been running a Macro that Imports from Excel. After the Import runs one
of my field data types is changing from text to number and I'm losing data.
My Import Spec, Table, and the Excel File all have text data types before the
Import but after my table is a number. Any thought on how I can fix this?

 

[Chris Reveille]

Add a dummy record to the Excel file for the first record with the correct
data types. You can delete that record after the import
or
Import into an existing table with the correct filed types