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