![odbc excel end at blank row odbc excel end at blank row](https://www.exceltip.com/wp-content/uploads/2013/07/img1277-415x300.jpg)
So I will just use an example of how to get the correct values instead of NULL. The workaround is hard to explain with words (aka just my incompetence with writing). It also returns NULL if - instead of accessing it individually - I use the method `rangeObject.CopyFromRecordset(oRec)` (regardless if it's the first time or not I access it)ĭavi Furuya How to edit my message? I have to rectify my previous message. I'm able to reproduce this behavior consistently, not only with `colTEXT` (I have other columns too that exhibit the exact same behavior)
![odbc excel end at blank row odbc excel end at blank row](https://www.elastic.co/guide/en/elasticsearch/reference/current/images/sql/odbc/apps_excel_fromodbc.png)
**BUT**, if I access the last field - via the command `( - 1).Value` - and _then_ access `colTEXT` once again, it now returns the correct value In all the subsequent times I individually access it, it returns NULL (the bug described here) The command used is `(2).Value` (`colTEXT` is field number #2) In the first time I individually access `colTEXT`, it returns the correct value. That's the bug described here by Rafael Caesar Lenzi. Only `colTEXT` returns NULL value (in database it is not NULL). One of its fields (third column, or field number #2) comes from a TEXT column (I will call it `colTEXT`) In my program, I have a ADODB.Recordset object (I will call it `oRec`) with many fields (each field correspond to a column) Windows 7 Home Basic 圆4 ( Service Pack 1 Build 7601) in Taiwanese (ZH-TW) Excel 2010 (.5000 (32-bit)) - Microsoft Office Home and Business 2010 MySQL ODBC 5.3 Unicode Driver (5.3.4-win32) I will post a workaround that worked for me. Davi Furuya I experienced the same issue.