|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: code, excel, fields, fine, import, others, recognize, wont, zip |
|
|
Thread Tools | Display Modes |
|
#1
March 19th 06, 09:17 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Excel import won't recognize zip code fields, others are fine
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? 
|
| Ads |
|
#2
March 19th 06, 10:23 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Excel import won't recognize zip code fields, others are fine
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 "emspooner" wrote in message ... 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?
|
|
#3
March 21st 06, 06:39 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Excel import won't recognize zip code fields, others are fine
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 "Karl Timmermans" wrote: 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 "emspooner" wrote in message ... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mapping Fields During Import from Excel | Phil Rabichow | Outlook - Using Contacts | 2 | March 11th 06 06:09 PM |
| Import from excel into a custom form and fields in Contacts | John | Outlook - Using Contacts | 1 | February 1st 06 02:37 PM |
| Import Outlook Contact Postal Code from Excel | Vaughn | Outlook - Using Contacts | 1 | January 28th 06 12:14 PM |
| zip code | tn10 | Outlook - Using Contacts | 0 | January 13th 06 04:22 PM |
| zip code | tn10 | Outlook - Using Contacts | 0 | January 13th 06 04:21 PM |
Linear Mode
