Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / January 2004

Tip: Looking for answers? Try searching our database.

importing to contacts from excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
carol - 28 Jan 2004 17:25 GMT
i have successfully imported some fields from excel but
not others.  it appears that all my various phone number
fields are not importing.  i changed the format in excel
on these fields to text hoping that would resolve my
problem, but no luck.  can you help me out!?!  thx.
Karl Timmermans - 28 Jan 2004 18:01 GMT
Your phone numbers are being translated as numeric fields by the Outlook
import translator on your system. Suggest you try saving the file as a .CSV
file and import that file to see if it resolves the problem. This is an
issue with the standard import engine we saw on some systems but not others
when the ContactGenie products were being developed.

What the Excel import translator is doing is scanning your first 20 or so
rows for that column from what we can determine and decides on whether a
field is numeric or text from that. You may also want to try putting a text
character in front of the phone number in the first row or so and see if
that will force "text" recognition for the rest of the rows you are
importing.

What version of Outlook (and Excel) are you using?

Karl
Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com

> i have successfully imported some fields from excel but
> not others.  it appears that all my various phone number
> fields are not importing.  i changed the format in excel
> on these fields to text hoping that would resolve my
> problem, but no luck.  can you help me out!?!  thx.
carol - 28 Jan 2004 18:58 GMT
will try.  using excel 97 and outlook 98.  thx.
>-----Original Message-----
>Your phone numbers are being translated as numeric fields by the Outlook
[quoted text clipped - 20 lines]
>
>.
carol - 28 Jan 2004 19:01 GMT
alpha character in front of phone no. didn't resolve
problem.  thx.

>-----Original Message-----
>Your phone numbers are being translated as numeric fields by the Outlook
[quoted text clipped - 20 lines]
>
>.
carol - 28 Jan 2004 19:10 GMT
tried cvs with no luck either.  searched thru all outlook
fields just to see if it was throwing phone numbers (as
numbers, text, or junk) into any field but nothing. need
help with this project.  whatever you can suggest will be
appreciated. thx.

>-----Original Message-----
>Your phone numbers are being translated as numeric fields by the Outlook
[quoted text clipped - 20 lines]
>
>.
Karl Timmermans - 28 Jan 2004 23:43 GMT
I'd have offered you a (free) solution to your problem but unfortunately we
don't support Outlook '98 and the problem may well be an issue related to
the age of your programs which no longer exists in current releases. To be
honest, I have no idea anymore what Outlook '98 or Excel '97 supports
anymore in the way of import/export drivers but if either supports MS Access
2.0 we could possibly convert your data to that format just for you to test.

However, having said that - just to make sure I understand correctly - are
you saying that your phone numbers are not importing "at all" - i.e. as in
blank or are importing as strange numbers?

If you wish to contact me directly outside of this forum and send me a
sample of your data - will be happy to take a look in case we can find
something that stands out  (this is not intended as a general invitation for
everyone who is having a
problem :-) ). - Please make sure you reference this newsgroup should you
decide to follow-up. In terms of the data - we operate under an automatic
general non-disclosure agreement which is published on our website in case
confidentiality is an issue related to your data.

My bet is on the way your import drivers are scanning the data - a quick way
to prove that is to create a worksheet with only one contact and put any
non-numeric character in front of your phone number - then import that
single contact both via Excel and after saving it as a CSV file.

Karl

Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com

> tried cvs with no luck either.  searched thru all outlook
> fields just to see if it was throwing phone numbers (as
[quoted text clipped - 37 lines]
> >
> >.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.