Outloog Aceess links
 

Using Outlook XP, I would like to use some of my Outlook appointments in an
Access Query. Can someone explain how I can do this?

Outloog Aceess links
 

I don't think you can, natively. You'd probably have to export those
calendar entries to some other format like CSV or something that Access
can get into.

Outlook's PST format is not very natively accessible by other apps; not
even MS apps.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Bob Jann" wrote in message
:

Using Outlook XP, I would like to use some of my Outlook appointments in an
Access Query. Can someone explain how I can do this?

Outloog Aceess links
 

Thanks for your reply, Ben. I have been able to import selected data from my
Outlook calendar. The import created a table in Access called "calendar"
including the two items I asked for: Subject and Date date. Now, I want the
imported calendar field "Subject" to relate to the "Name" field in another
table so that Person A's appointment can be displayed on the same query with
other information about person A contained in a table named "Persons". Can
this be done?

"Ben M. Schorr - MVP (OneNote)" wrote in message
...
I don't think you can, natively. You'd probably have to export those
calendar entries to some other format like CSV or something that Access can
get into.

Outlook's PST format is not very natively accessible by other apps; not
even MS apps.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Bob Jann" wrote in message
:

Using Outlook XP, I would like to use some of my Outlook appointments in
an
Access Query. Can someone explain how I can do this?

Outloog Aceess links
 

Well, I'm impressed you got that far to be honest. I think you may have
to ask the folks in the Access group for details on relating the fields
in query.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Bob Jann" wrote in message
:

Thanks for your reply, Ben. I have been able to import selected data from my
Outlook calendar. The import created a table in Access called "calendar"
including the two items I asked for: Subject and Date date. Now, I want the
imported calendar field "Subject" to relate to the "Name" field in another
table so that Person A's appointment can be displayed on the same query with
other information about person A contained in a table named "Persons". Can
this be done?

"Ben M. Schorr - MVP (OneNote)" wrote in message
...

I don't think you can, natively. You'd probably have to export those
calendar entries to some other format like CSV or something that Access can
get into.

Outlook's PST format is not very natively accessible by other apps; not
even MS apps.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Bob Jann" wrote in message
:


Using Outlook XP, I would like to use some of my Outlook appointments in
an
Access Query. Can someone explain how I can do this?