Type difference when importing from Excel

[SeniorCitizen]

I have a problem with type conversion when importing a spread sheet exported from another commercial database. The postal code in the table I'm importing into is defined a short text, because some may be international. The Excel field content happens to be all numeric with the little triangle at the top left of the first number. I tried to copy it here but the triangle did not copy. When I run the import all fields come in properly, including the currency fields marked with the same triangle, except the postal code. I get the type conversion error on the postal code and it changes the field definition in the table from short text to numeric. I am at a loss. I'm this has been handled before so any thoughts are welcomed.

[June7]

When you click on the 'little triangle' what message do you get?

I am not able to replicate issue.

If you want to provide sample worksheet, follow instructions at bottom of my post.

[NoellaG]

In excel you get a little triangle in the left upper corner when you put a number in a cell that is formatted as text.


What I find strange is that if you are importing the data by appending these into an existing table, this action causes the field definition to change from a text field to a numeric field. IMO this can only happen if you do the import through VBA code.
So to check this, we would need the code you use to import the excel sheet into Access.