Import spreadsheet wizard not working

[Themba via AccessMonster.com]

I’m trying to import a spreadsheet from excel into access there’s customer
number column that has numeric values and text values. But I have converted
the entire column into text in Excel before importing it. It doesn’t seem to
work cause not all data gets imported.Only the numbers get imported and the
values starting with an alphabet within that column get left out in Access.
Even when I try to change the Data type in The ‘Field Options’ in the Import
Spreadsheet Wizard .It is Greyed Out.Why is the Data Type field In the Import
spreadsheet wizard greyed out.