Excel problem reading data when aflanumreic field is numeric

V

Verhaad

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine xls file's codepage/collation 0
EXCEL Spreadsheet CELLS have data but load as NULL 4
Excel data numeric type read problem 0
Leading Zeros are lost when importing spreadsheet data 7
Error reading Excel data 1
Reading data from Excel Worksheet in vb 3
Problem reading Excel 2003 file through OleDB 1
ADO connection not opening in Excel 2003 0

Top