Simply changing the connection string doesn't work as I've tried before.

David Greenberg (4/28/2008)

---

I found an easier way using steps in this MS KB article on the very same subject. I...

Much easier way is:

Load the Excel file with First Row as Header off even it contains the header. This can ensure all the fields are read in text format. And...