How do I Import tables from Access 2000 into Outlook 2000?

T

The Big O

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.
 
S

Sue Mosher [MVP-Outlook]

File | IMport and Export

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
T

The Big O

I have no luck with understanding instructional books and I was hoping that
someone in this discussion group could guide me in the right direction
without trying to sell me another book.
 
S

Sue Mosher [MVP-Outlook]

No one is trying to sell you a book. If you use the command indicated and follow the step-by-step wizard, you can complete the desirred task. Did you even try it?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
T

The Big O

I'm sorry I misunderstood your message and I appreciate your help. I am happy
to tell you that this morning 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?
 
S

Sue Mosher [MVP-Outlook]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
T

The Big O

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.
 
S

Sue Mosher [MVP-Outlook]

Ideally, the zip code field should be not a number but a text, so it can support Zip+4. Same with apartment number. Sounds like the database designer never heard of Apartment 3G.

If it were my project, I might use a make table query to create a new table that has the existing fields that have no problem + a text (not numeric) field for the zip + a text field for the apartment number. See http://www.ehow.com/how_14046_create-make-table.html
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top