| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel problem reading data when aflanumreic field is numeric
Hi,
i'm facing the following probem when i import records from an excelfile by code (i use OleDbDataAdapter and OleDb.OleDbConnection provider=Microsoft.Jet.OLEDB.4.0;.....Extended Properties=Excel 8.0): When an alfanumeric field contains numeric data (like "1234556" the data is imported as "<NULL", but if this alfanumeric field contains data like "AB123456" the value "AB123456" is imported. I want to know how i can solve this because the data read is very critical, the null-values give wrong outcomings. Thanks for yor effords. Greetings, Verhaad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading Only Numeric Value of Cell | Excel Discussion (Misc queries) | |||
| how to tell excel to read numeric field as character fr a csv file | Excel Discussion (Misc queries) | |||
| Merge an alpha field and a numeric field | Excel Discussion (Misc queries) | |||
| Problem pasting numeric data from Access into Excel | Excel Discussion (Misc queries) | |||
| Programmatically reading data field values from PivotTable | Excel Programming | |||
Threaded Mode
