To tell you the truth - it's somewhat of an anomoly to me - since some files
import properly and some don't using the standard import engine. To the best
of my knowledge (and I'd love to stand corrected on this by anyone who knows
better) - the standard Jet engine previews the first 25 records or so (I
forget the exact number it looks at) to determine field type and it doesn't
seem to matter if the field is formatted as a text field or a numeric field
in Excel (but we don't find that to be consistent in all cases). I doubt
very much that very many people create the necessary file to over-ride the
default settings. Mind you - given the multitude of combinations and
permutations of O/S's, Outlook, Excel, MDAC, and Jet versions - must admit
haven't wasted too much time on it either once we worked around it in a
definitive manner across all scenarios.
In any event - we use our own method and it's not an issue for ContactGenie
no matter how the inbound field is designated for a phone number . One thing
you may want to try is exporting your file to a >CSV format and see if that
makes a difference on your system (sometimes it does and sometimes it
doesn't).
Karl
--
___________________________________
Karl Timmermans - The Claxton Group
ContactGenie - "automated contact importer for MS Outlook '2000/2002
h!!p://contactgenie.claxton.com (replace "!!" in address with "//")