http://www.dicks-blog.com/archives/2...ed-data-types/

http://support.microsoft.com/default...b;en-us;257819
How To Use ADO with Excel Data from Visual Basic or VBA

--
Regards,
Tom Ogilvy

"kirkm" wrote in message
...
Does anyone know how to set IMEX=1 in the connection strings extended
property ?

Thanks - Kirk