I'm trying to debug a program which gets values from a Sybase database and exports those data to a Excel Worksheet, all is fine but when there is a value '001' from the database the exported valued to the worksheet is a null character.
That is strange so i'm wondering if any of you's ever encountered something like that .... the closest thing I could find that would do any sort of filtering is the code below:
If rs("db_value").Value <> vbNull Then // Add value to worksheet End If
Could it be that '001' is interpreted as a vbNull ?
By the way "db_value" is a varchar.