Not sure, but I do know that excel treats zip codes as numbers and
strips the zero off the front end for zip codes beginning with a zero.
Are your problem records from the northeast where those zip codes are
found?
If you tell excel to display the number as a zip code, it will add that
zero where it encounters numbers that are only 4 digits long, but I
believe it still treats it as a number. I don't recall if excel can
change that "feature" or if you can export to a tab-delimited file to
then import into ebase. Alternatively, if this is your problem you
could probably have filemaker find the problem zips and correct the
problem by adding a zero to the front end.
Carl
office wrote:
>
> Hope someone can help me with this minor problem...
> I am trying to import names into ebase and everything is working fine except
> the zip code. It is importing as four digits instead of five. I have
> imported before and not had a problem so I'm not sure what I'm doing wrong.
> And, other than the zip code, the import is working great. I am importing
> from an excel file which shows the correct five numeral zip code. Any
> suggestions? They'd be very much appreciated.
>
> Thanks,
> Pam McChesney
> Shoreline Arts Alliance
>
> - - - - - - - - - - - - - - - - - - - -
> Shoreline Arts Alliance
> www.shorelinearts.org
> Discover the best music, theatre and
> arts events on the Shoreline:
> www.shorelinearts.org/calendar.cfm
>
> ------------------
> Reminder to each recipient: To change your list account preferences, go to
> http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email
>address you used to subscribe to the ebase support list:: [EMAIL PROTECTED]
>
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
> ---------------------------------------------------------------------
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
