 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / November 2006How 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. File | IMport and Export  SignatureSue 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 >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. 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. > File | IMport and Export > > >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. 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? SignatureSue 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 >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. > >> File | IMport and Export >> >> >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. 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? > 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? > [quoted text clipped - 9 lines] > >> > 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. 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/ SignatureSue 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 > when I went into Outlook and opened the import > wizard I was able to get data base tables to copy into the individual [quoted text clipped - 12 lines] >> >> > 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. 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. > 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/ > [quoted text clipped - 14 lines] > >> >> > 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. 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 SignatureSue 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 > Hello Sue: > Tried both the solutions in the article and nothing solved my problem. I [quoted text clipped - 12 lines] > >> 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/ >> >> > when I went into Outlook and opened the import [quoted text clipped - 13 lines] >> >> >> > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.