Sorry it took so long to reply to your suggestions. I got pulled off onto another assignment. Koen hit it on the head with the TYPEGUESSROWS setting. ...

Koen pointed something out that I will look at. It appears to be using an ACE driver to interface with Excel rather than JET. Maybe that is why...

The IMEX=1 doesn't appear to do anything. I've seen other posts where people said this setting in the connection string worked perfectly for a 2003 excel spreadsheet, but not...