With automation using ADOs, it seems that whenever a client sends an Excel spreadsheet with no formatting (schema), connecting to the spreadsheet via ADOs seems to trigger the Microsoft Jet Engine driver to determine data types for fields. On a zipcode field that comes as “General”, if the first 5 records have no alphas, the driver calls it Long Integer and fails to accept foreign zipcodes with alphas or other formats. Is there a programming solution or a driver patch to resolve this issue?NOTE: this problem is not just an Excel 2000 problem…Access 2000 and SQL 2000 behave exactly the same with the same spreadsheets.
