EXCEL To SQL

[Injun]

I have an excel file with jobnumbers ( 8 digit numbers)
But occassionally I do get alphanumeric jobnumbers (MISC, TRNG..etc) . I am using ADO.net to connect to Excel and using dataset to read it. I am getting all the numeric jobnumbers right but others come as NULL.
How can I fix that. I cannot manually do anything to the excel file , it is generated from another program.
Any help appreciated.

 

[druer]

What does the Excel sheet have in it? Does it have the Alpha Job numbers?
If the Excel sheet has the Alpha Job Numbers in it, and the column is formatted for Text then all should be good. Are you possibly defining the result set ahead of time and defining the expected field as numeric or something?

 

[Injun]

My jobnumbers look like this

6304459
6304458
6304457
6304415
MISC
6304451
6304315
TRNG

It doesnt read the MISC , TRNG etc.
Only the numeric jobnumbers.I looked at the format of the column in Excel and it's General.

 

[rstum2005]

so try changing the field data type to "text