>Okay...
>
>I've tried to reproduce your problem using the data you show below. With the oledb driver, I'm getting the same null results that you do; however, with our direct access service, we get the proper results returned.
>
>We had a lot of trouble using Oledb to import excel, that we now use a form of automation to do it which results in better control over the data. If you want, I can provide sample code. Its in c#.
>
>
It means that you need to have Excel installed, right?
I think it would be nice to see the code. Looks like Arryel Cabansag is having similar problems.
If it's not broken, fix it until it is.
My Blog