Access Cannot import Excel data

[maupiti]

Access Cannot import Excel data where the field contains alphanumeric character

I had a predefine Access Table that is empty.
The table has the following fields:
Wire_Number Text
Gauge Number
Color Text
Length Text

When I import an excel file into this table, it import all of the records, but for the one where the Wire_Number is 320A and 320B, the field is blank.
So there are two records where the Wire_Number is blank
even though the field is declared as Text.

Also, Access created a table named
'Modified WorkSheet$'_ImportErrors.
This table referenced the two record that
was not imported properly.

Error Field Row
Type Conversion Failure WireNo 12
Type Conversion Failure WireNo 13

 

[easyit]

Hi,
Check the fieldtype of these records in Excel, maybe change them.

Excel has mysterious ways of presenting data...

 

[maupiti]

Hi easyit, and thank you for your response. I did
change the WireNo field in Excel to text, and the WireNo field in Access to text also. When I did an import, Access flag an error where the data value is alphanumeric even though in Access it had been defined as text.

 

[easyit]

how do you import?