"nate axtell" <naxtell at progeny dot net wrote in message
...
Thanks again for the link, Dick.
I was checking out the registry for ImortMixedTypes and I found mine set
to
"Text".
The link you posted says "IMEX=0 and IMEX=2 result in ImportMixedTypes
being
ignored and the default value of 'Majority Types' is used. IMEX=1 is the
only way to ensure ImportMixedTypes=Text is honored"...

Do you know if this means that the ImortMixedTypes key is supposed to be
"Majority Types" by default or that that is just a default that is used by
the driver? I am worried that ImportMixedTypes wont be "Text" for every
clients' installation by the wording of the qoute above. If it is always
Text then I should be fine.


The way I understand it is that ImportMixedTypes is "Text" by default. But
IMEX is NOT 1 by default, so ImportMixedTypes is ignored - by default. It
would follow then that if you declare IMEX in your extended properties AND
the user has not changed their default, then it will work. I think that
"the default value of 'Majority Types' is used" means that IMEX < 1 by
default and Majority Types is the default for an IMEX < 1, not that
Majority Types is the default for that registry key.

Whether you want to rely on user's default not being changed is up to you.
On my Win98SE, it's "Text" and I know I've never changed it.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com