Size Matters?

Problem Description:

• 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?

  Problem Solution:

• 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.