A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2006, 03:46 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?

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.
  #2  
Old November 16th, 2006, 04:24 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?

File | IMport and Export

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

  #3  
Old November 17th, 2006, 10:27 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?

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.

"Sue Mosher [MVP-Outlook]" wrote:

File | IMport and Export

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


  #4  
Old November 17th, 2006, 10:55 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?

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

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


  #5  
Old November 20th, 2006, 03:21 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?

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?

"Sue Mosher [MVP-Outlook]" wrote:

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

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


  #6  
Old November 20th, 2006, 04: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.


  #7  
Old November 21st, 2006, 02: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.



  #8  
Old November 21st, 2006, 03:02 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?

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



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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.