Is there a size limitation on importing an Excel column via ODBC?
I have a sheet that has a number of columns. When I try to import it, I get “[Microsoft][ODBC Excel Driver]COUNT field incorrect “
I’ve narrowed the problem down to a column where each cell contains > 256 characters. Does this matter?
- Even though the field contained text, when the ODBC reader attempted to grab it, it automatically deduced it was a Double field.
- Hence, it couldn’t populate a Double field with Text data.
- The solution was to simply format the cell as Text first, then let the reader do its work.