Excel import won't recognize zip code fields, others are fine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emspooner - 19 Mar 2006 22:17 GMT

I am importing contact information from Excel. All other data comes through
find into the import, but the 2 zip code fields are not recognized. Why not?

Reply to this Message

Karl Timmermans - 19 Mar 2006 23:23 GMT

Would be helpful if you defined what you mean by "are not recognized". Do
you mean that these fields are not being imported at all or appear to be
imported "incorrectly" (i.e. importing with a decimal extension etc)?

To minimize back 'n forth msg's - if the problem you're having is the latter
(which is generally the most common issue) - then the cause is that the Zip
Code is being treated as a "numeric" field (especially if you have the
format of 99999-9999). Change the column to text format. If that fails, save
the worksheet as a CSV file and import that file instead.

Karl

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

>I am importing contact information from Excel. All other data comes
>through
> find into the import, but the 2 zip code fields are not recognized. Why
> not?

Reply to this Message

emspooner - 21 Mar 2006 19:39 GMT

Karl - thank you for your help. My problem was that the zip code fields did
not show up at all. I tried creating a csv file from the data and that
import worked.

Elaine

> Would be helpful if you defined what you mean by "are not recognized". Do
> you mean that these fields are not being imported at all or appear to be
[quoted text clipped - 18 lines]
> > find into the import, but the 2 zip code fields are not recognized. Why
> > not?

Reply to this Message

Rate this thread: