There are users who when they runs this code have records pull blanks for one of the fields . This field is set up as Text on the import table. The records in Excel contain data that are a mix of numbers and text (ex. DN, 1D, 23, etc.).
On one user's PC, we changed acSpreadsheetTypeExcel97 to acSpreadsheetTypeExcel9 and it works fine. But, on another PC it makes no difference.