Import Spreadsheet Wizard not working

[thembela]

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.

 

[Remou]

I think that when you are importing from Excel, the type is taken from the first cell in the column, if it is numeric, the column will be treated as numeric. So I suggest that you edit your spreadsheet to make the first cell an alpha identifier or you create a table and import into that.