Posted: Tue Oct 12, 2010 3:29 am
What is the ODBC Data type for this column declared as?
A short text to describe your forum
http://dsxchange.com./
The ODBC Data type for this column is VARCHAR(255)ArndW wrote:What is the ODBC Data type for this column declared as?
Removing the formatting OR removing the formatting and reformatting as text does not help. The only way for this to show up as I have found is to have the numeric value prefixed with an apostrophe.ArndW wrote:That sounds really strange. If you select all cells and remove formatting in the document, does the error persist?
There are no leading zeros or negative numbers in this column, The numbers are like , 10,22,55 etc and these show up as NULL while viewing the data and hence NULL when extractedArndW wrote:I don't have access rights on my current machine to check if this is reproduceable since it sounds too strange. Are the numeric contents that come across as NULL all of a similar tpye, i.e. with leading zeroes or negative values? Do values such as "123" not get transferred correctly?
There are no leading zeros or negative numbers in this column, The numbers are like , 10,22,55 etc and these show up as NULL while viewing the data and hence NULL when extractedArndW wrote:I don't have access rights on my current machine to check if this is reproduceable since it sounds too strange. Are the numeric contents that come across as NULL all of a similar tpye, i.e. with leading zeroes or negative values? Do values such as "123" not get transferred correctly?