Import Outlook calendar to access

[terre]

I note that it is easy to link Ms Access 2007 to the Outlook Calendar.
However, when I do so the startDate and EndDate fields aren't there.
I wish to be able to see appointment dates from within the access database.
Is it possible?

 

[lameid]

My recommendation would be to write a query to get the min and max dates of the calendar items and figure out to group by the subject or whatever is necessary to make it unique... Otherwise you would have to use Outlook automation to progammatically view the calendar items... even then I never poked at recurring meetings so I'd have to dig around. Hopefully you can find a code sample with a search engine.