AnsweredAssumed Answered

Exporting to Excel, sometimes result can't import into Access?

Question asked by cartographer4 on Jul 26, 2016
Latest reply on Aug 2, 2016 by xander_bakker

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?

Outcomes