Outlook 2002; Windows XP
Hello,
I want to be able to link an Outlook calendar to an Access database for the
purpose of generating reports in Access (grouping level reports based on
Outlook categories - I have not seen how to do this in Outlook, and Access
makes it so easy to do).
I read on the Microsoft website that you can do this with Outlook contacts
and thought, why not try it with an Outlook calendar.
I created a blank database in Access and created a new, linked table,
seleting my Outlook calendar as the data source. It created a linked table
in Access, however, the fields it imported into the Access table were not the
Outlook calendar fields.
How can I get Access to import the calendar fields into the linked table??
Thanks for your help,
Jeff
Sue Mosher [MVP-Outlook] - 18 Feb 2005 20:01 GMT
The linked table method has major limitations, including the inability to
show even all the reasonably important fields. While articles have been
written on how to expand on this method's obvious features, I've never been
able to duplicate the results. See
http://www.outlookcode.com/d/database.htm#linkedtables .
That page will also give you other ideas on how to work with databases and
Outlook together. You'll need to write code or use a third-party tool that
does the heavy lifting.

Signature
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
> Outlook 2002; Windows XP
>
[quoted text clipped - 20 lines]
>
> Jeff