Another concern,
I have tried IMEX=1 with the Jet driver and I DO see the results I want,
Number fields and Text fields are being returned together.
but in the case where a number is quite long I see 9911220193 in the excel
file but when it gets read into the recordset and then passed over to SQL
server I see "9.91122E+009". This is quite strange. Any idea why this
scientific notation is showing up?
Thanks again,
Nate