Link Outlook calendar as an Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Jeff,

I've never tried this myself with an Outlook Calendar folder and don't
know just what you're seeing. But 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 could export the relevant fields to a text file and link
that into Access for analysis. And it's always possible to write VBA
code that uses the Outlook object model to do just about anything.

For Outlook information, good places are www.slipstick.com and
www.outlookcode.com
 
Back
Top