View Single Post
  #6  
Old November 20th, 2006, 03:14 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 7,177
Default How do I Import tables from Access 2000 into Outlook 2000?

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.