View Single Post
  #7  
Old November 21st, 2006, 01:47 PM posted to microsoft.public.outlook.contacts
THE BIG O
external usenet poster
 
Posts: 28
Default How do I Import tables from Access 2000 into Outlook 2000?

Hello Sue:
Tried both the solutions in the article and nothing solved my problem. I
don't have data that contains hyphens, or parentheses as the article claimed,
and even when I changed the data to a text form (my program doesn't
specifically allow me to save it as a csv. file, but lumps them all under
text) Outlook wouldn't allow me to import that form. I saw where it stated
the zip codes are coming up with a decimal point followed by 3 zeros, but
then it didn't give a solution for that particular problem.
I tried going into the design view on the individual Access table and
changing the decimal entry from auto to zero, but that didn't help.
I also would like to know how I can change the existing data to add wording
to the effect of Apt. # 1701 to designate it as such in the Outlook address.
Can that be changed in the Assess design view or not? My problem the previous
individual who designed the initial Assess database I am now working from.

"Sue Mosher [MVP-Outlook]" wrote:

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.