View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Verhaad Verhaad is offline
external usenet poster
 
Posts: 1
Default 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