Wednesday, April 23, 2008

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.

No comments:

Post a Comment