Importing Outlook to Access

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have Office 2003 . I have a public folder where I keep requests . I want to
bring those Outlook items into Access. I found a utility on Microsoft WEB
site to do this ( see below) but I can not find anything for Office 2003.
: Article ID : 175901
Last Review : August 28, 2007
Revision : 2.2
This article was previously published under Q175901
 
When I try to install it is saying that Access97 wizards is not installed .
PLease install.
 
Sorry, I misread the title of the article. 175901 relates to Outlook
personal address books which are not the same thing as public folders
(which are normally accessed via Outlook and managed by Exchange
Server. In Access 2003 you should be able to use File|Get External
Data and select Exchange() as the data source.
 
Thanks for response. That method only brings in fields that are on the view
of the folder not the complete form.
 
This is where things get complicated - so much so that I never really
got the hang of it (and fortunately I haven't needed to<g>). The
following summarises where i got to last time I tried:

The "fields" you see in the usual Outlook forms are only indirectly
related to the actual
data stored wherever that particular installation of Outlook stores
it. For instance, for Contacts there are

1) the "fields" in the usual Contacts form, which are a subset of
2) the much wider set of "contact fields" available in the Outlook
Define Views dialog, which correspond more or less one-to-one to
3) the *properties* exposed by the Contact object in the Outlook
object model, which are *not* the same as
4) the actual data fields that are stored.

And then there are
(5) the fields that appear when you try and export from or link to the
Contacts folder.

As I understand it, just what appears in (5) is determined to some
extent by the current view of the folder, so you might try altering
the view and re-linking to Access. Otherwise, you can always get
pretty much what you want by using the Outlook object model via
Automation.

Here are some useful links:

Accessing Microsoft Exchange and Outlook Data Using Visual Basic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnout98/html/olexcoutlk.asp

Sample Procedure to Link a Microsoft Outlook Folder
http://support.microsoft.com/?id=209946

How to programmatically export Outlook items to Access
http://support.microsoft.com/?id=290792
http://support.microsoft.com/?id=253794

OL2000: How to Programmatically Import Outlook Items from Microsoft
Access
http://support.microsoft.com/?id=208232

Using Automation in Microsoft Office Access 2003 to Work with
Microsoft Office Outlook 2003
http://msdn2.microsoft.com/en-us/library/Aa159619(office.11).aspx

Finally, the best places I know for information about Outlook are
http:www.outlookcode.com and http://www.slipstick.com
 
Back
Top