home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,413 of 10,840   
   Derk to All   
   Reading Excel Spreadsheet in VB - data t   
   13 Apr 05 15:29:49   
   
   From: derrick.king@bradford.gov.uk   
      
   I have an VB App that reads an Excel Sspreadsheet and it seems to having   
   problems determining the data type of a column. The column in question has   
   alpha numeric content eg S001, B123 or 1234. I am aware that when reading   
   Excel Spreadsheets it will determine the datatype of a column, by looking at   
   the content of the first few rows. If it determines that the column is text,   
   then all numeric cells/fields are returned as null and if the column is   
   determined as numeric, then all text fields are returned as null.   
      
   Many Thanks   
      
   Derrick   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca