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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why getting dup contact field data when import Excel to Outlook ? 7
importing to outlook, zip code column will not come with the rest 1
Import Contacts From Excel to Outlook Not Working 3
importing from Excel 1
Problem importing ZIP codes from Excel 2002 into Outlook 2003 cont 1
Importing contacts from Excel 5
Zip Codes won't export from my outlook contacts to excel 2
Format imported zip code to appear in Contacts w/o decimals? 1

Back
Top