Using the ArcGIS Desktop 10.4 Table to Excel Arctoolbox script in the Conversion Tools -> Excel I am sometimes able to make an Excel 97-2003 document that imports directly into Microsoft Access without any issues using the
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Table", strFilename, True
method, but sometimes it fails, and I have to open the document in Excel and save as a document of 97-2003 format with my Excel 2013.
Why does it not always work? Can null values in certain fields create a problem?