The issue is that your Access data is numeric, while the values in Outlook are strings. This article describes the problem and suggests a couple of solutions:
http://support.microsoft.com/kb/238323/
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"The Big O" wrote in message ...
when I went into Outlook and opened the import
wizard I was able to get data base tables to copy into the individual
designated Outlook folders, however I have noticed two errors in the imported
data. Both my zip codes and apartment numbers are coming out like the
following example: 1701.000. Is this problem with the original Assess 2000
data or Outlook? I would also like to know there is a way I could designate
the apartment number information with a heading stating apartment number
(Apt. 1701) in my Outlook address box in the form or will I have to reimport
this information after after correcting the Assess table info?
"Sue Mosher [MVP-Outlook]" wrote:
File | IMport and Export
"The Big O" wrote in message ...
I am attempting to import a series of contact tables (Quantity 11) from a
previously set up Access 2000 database into Outlook 2000 to use all the
features of the Outlook program. I am not as schooled in the working of
Access and feel the Outlook functions would better serve our current needs.