excel data not reading right

[Injun]

I'm trying to export data from an Excel file into sql . I can get it to run and fill m dataset but it's only pulling numeric data from a certain column called JobNo. I looked at the format of the column in Excel and it's General. There ARE alphanumeric jobnumbers in there also but they, for some reason, are being excluded and come out as null.
How can I rectify this?

 

[ca8msm]

First, try posting an example of the code you are using...


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.