From MS Access 2007 open a Excel workbook. Then change column A formating to general.
Column A currently has [=1]"ONE";[=0]"////";General
I'm going to do a filecopy of the Excel workbook, then change the copied workbook column A formating to general
The reason for changing the formating , when importing only th "ONE" is imported even if there is another value entered.