Re: Export Exchange Public Calendar

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.

If you want to write Outlook object model code to iterate the folder, you
need to walk the folder hierarchy using the Folders collections or use a
function that does that for you. See
http://www.outlookcode.com/d/code/getfolder.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"TommyU" <TommyU@discussions.microsoft.com> wrote in message
news:3BE3D65F-4649-4E67-89FD-3B64227AA99D@microsoft.com...
> How can I open a connection to an Exchange Public Calendar? I need to
import the appointments into an Access DB. I know how to write items to a
Public Calendar and I know how to link to an Exchange folder in Access, but
it doesn't give me all fields I need when I link. Can I use ADO to connect
directly to the calendar and see all the field names? Or, can you choose
the fields I need when I link to a calendar?
>
> Tommy

Thanks for the reply. I have no problem writing the code to create a recordset to pull the data I need. I guess I just need to find the schema for the table so I can get the field names. Then I could just create a connection to that calendar and pull the data out record by record, correct?

"Sue Mosher [MVP-Outlook]" wrote:

> 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.
>
> If you want to write Outlook object model code to iterate the folder, you
> need to walk the folder hierarchy using the Folders collections or use a
> function that does that for you. See
> http://www.outlookcode.com/d/code/getfolder.htm
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "TommyU" <TommyU@discussions.microsoft.com> wrote in message
> news:3BE3D65F-4649-4E67-89FD-3B64227AA99D@microsoft.com...
> > How can I open a connection to an Exchange Public Calendar? I need to
> import the appointments into an Access DB. I know how to write items to a
> Public Calendar and I know how to link to an Exchange folder in Access, but
> it doesn't give me all fields I need when I link. Can I use ADO to connect
> directly to the calendar and see all the field names? Or, can you choose
> the fields I need when I link to a calendar?
> >
> > Tommy
>
>
>

The "schema" is the Outlook object model. You can use the object browser in
VBA to look at the properties of the AppointmentItem object.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"TommyU" <TommyU@discussions.microsoft.com> wrote in message
news:9EB09AB5-B9AC-48A5-A4DE-5C9A38E8D664@microsoft.com...
> Thanks for the reply. I have no problem writing the code to create a
recordset to pull the data I need. I guess I just need to find the schema
for the table so I can get the field names. Then I could just create a
connection to that calendar and pull the data out record by record, correct?
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
> > 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.
> >
> > If you want to write Outlook object model code to iterate the folder,
you
> > need to walk the folder hierarchy using the Folders collections or use a
> > function that does that for you. See
> > http://www.outlookcode.com/d/code/getfolder.htm
> >
> > --
> > Sue Mosher, Outlook MVP
> > Author of
> > Microsoft Outlook Programming - Jumpstart for
> > Administrators, Power Users, and Developers
> > http://www.outlookcode.com/jumpstart.aspx
> >
> >
> > "TommyU" <TommyU@discussions.microsoft.com> wrote in message
> > news:3BE3D65F-4649-4E67-89FD-3B64227AA99D@microsoft.com...
> > > How can I open a connection to an Exchange Public Calendar? I need to
> > import the appointments into an Access DB. I know how to write items to
a
> > Public Calendar and I know how to link to an Exchange folder in Access,
but
> > it doesn't give me all fields I need when I link. Can I use ADO to
connect
> > directly to the calendar and see all the field names? Or, can you
choose
> > the fields I need when I link to a calendar?
> > >
> > > Tommy
> >
> >
> >

No, you're not on the right track. Unless your code is running on the
Exchange Server itself, which would let you use ExOLEDB to connect to a
folder with ADO, you will need to iterate the folder and work with the
properties of each item.

Furthermore, Outlook doesn't have tables. It's a semi-structured database,
which means that each Outlook folder can hold different types of items. The
properties of the item object are what you're looking for.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"TommyU" <TommyU@discussions.microsoft.com> wrote in message
news:A4DEB64D-BE7F-49E4-9A4B-4454C584382B@microsoft.com...
> I thought the object browser would only show me the properties of the
AppointmentItem object. Maybe "schema" is not the right word. I would need
to know the field names in the "table". That is something like--Subject,
StartTime, EndTime, Duration, etc. Then, I should be able to open a
Recordset with ADO and extract the items. Am I on the right track?
>
> Tommy
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
> > The "schema" is the Outlook object model. You can use the object browser
in
> > VBA to look at the properties of the AppointmentItem object.
> >
> > "TommyU" <TommyU@discussions.microsoft.com> wrote in message
> > news:9EB09AB5-B9AC-48A5-A4DE-5C9A38E8D664@microsoft.com...
> > > Thanks for the reply. I have no problem writing the code to create a
> > recordset to pull the data I need. I guess I just need to find the
schema
> > for the table so I can get the field names. Then I could just create a
> > connection to that calendar and pull the data out record by record,
correct?
> > >
> > > "Sue Mosher [MVP-Outlook]" wrote:
> > >
> > > > 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.
> > > >
> > > > If you want to write Outlook object model code to iterate the
folder,
> > you
> > > > need to walk the folder hierarchy using the Folders collections or
use a
> > > > function that does that for you. See
> > > > http://www.outlookcode.com/d/code/getfolder.htm

> > > >
> > > >
> > > > "TommyU" <TommyU@discussions.microsoft.com> wrote in message
> > > > news:3BE3D65F-4649-4E67-89FD-3B64227AA99D@microsoft.com...
> > > > > How can I open a connection to an Exchange Public Calendar? I
need to
> > > > import the appointments into an Access DB. I know how to write
items to
> > a
> > > > Public Calendar and I know how to link to an Exchange folder in
Access,
> > but
> > > > it doesn't give me all fields I need when I link. Can I use ADO to
> > connect
> > > > directly to the calendar and see all the field names? Or, can you
> > choose
> > > > the fields I need when I link to a calendar?