Calendar Extraction

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

Guest

Hello, I was wondering if there is a way to do a bulk extraction of 30
calendars in MS Outlook to a form that can be used in MS Access?

I know about exmerge but it only extracts to a pst file but is there a way
to use that pst file in MS Access?

Thanks for your help.
 
..pst files can only be used by Outlook, no other program, so no, Access
could not use the files.

Why not explain what you are trying to do so perhaps someone here can assist
with another method than what you are contemplating?


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, C. Morris asked:

| Hello, I was wondering if there is a way to do a bulk extraction of 30
| calendars in MS Outlook to a form that can be used in MS Access?
|
| I know about exmerge but it only extracts to a pst file but is there
| a way to use that pst file in MS Access?
|
| Thanks for your help.
 
We want to take this info to see trends...i.e. how many students we seen from
9am-11am or which times of the day was most busy and such data. Say if we
had 25 advisors we want to see trends for. I want to be able to get to their
calendar info all at the same time and create reports.
 
You might want to look into Crystal Reports then. Access would seem the
least apt application for this purpose. Even an export to Excel would be a
better choice.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, C. Morris asked:

| We want to take this info to see trends...i.e. how many students we
| seen from 9am-11am or which times of the day was most busy and such
| data. Say if we had 25 advisors we want to see trends for. I want
| to be able to get to their calendar info all at the same time and
| create reports.
|
| "Milly Staples [MVP - Outlook]" wrote:
|
|| ..pst files can only be used by Outlook, no other program, so no,
|| Access could not use the files.
||
|| Why not explain what you are trying to do so perhaps someone here
|| can assist with another method than what you are contemplating?
||
||
|| --Â
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. Due to
|| the (insert latest virus name here) virus, all mail sent to my
|| personal account will be deleted without reading.
||
|| After furious head scratching, C. Morris asked:
||
||| Hello, I was wondering if there is a way to do a bulk extraction of
||| 30 calendars in MS Outlook to a form that can be used in MS Access?
|||
||| I know about exmerge but it only extracts to a pst file but is there
||| a way to use that pst file in MS Access?
|||
||| Thanks for your help.
 
What I'm looking for is a way that I can extract multiple calander info and
find trends...ie. how many students were seen between 9am and 11am or at what
time we had the most users and the like. Maybe a separate application after
the extraction? Can the multiple calendars info be combined to one file with
the info of who appointments they are (Owner)?
 
Well, some basic information that you have not yet supplied might be
helpful.

1. What version of Outlook?
2. Are you using Exchange server?
3. Have you looked at any other application (such as Excel which has good
reporting abilities)?
4. If you have looked at other applications besides Access, what did you
find lacking?


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, Milly Staples [MVP - Outlook] asked:

| You might want to look into Crystal Reports then. Access would seem
| the least apt application for this purpose. Even an export to Excel
| would be a better choice.
|
| --
| Milly Staples [MVP - Outlook]
|
| Post all replies to the group to keep the discussion intact. Due to
| the (insert latest virus name here) virus, all mail sent to my
| personal account will be deleted without reading.
|
| After furious head scratching, C. Morris asked:
|
|| We want to take this info to see trends...i.e. how many students we
|| seen from 9am-11am or which times of the day was most busy and such
|| data. Say if we had 25 advisors we want to see trends for. I want
|| to be able to get to their calendar info all at the same time and
|| create reports.
||
|| "Milly Staples [MVP - Outlook]" wrote:
||
||| ..pst files can only be used by Outlook, no other program, so no,
||| Access could not use the files.
|||
||| Why not explain what you are trying to do so perhaps someone here
||| can assist with another method than what you are contemplating?
|||
|||
||| --Â
||| Milly Staples [MVP - Outlook]
|||
||| Post all replies to the group to keep the discussion intact. Due to
||| the (insert latest virus name here) virus, all mail sent to my
||| personal account will be deleted without reading.
|||
||| After furious head scratching, C. Morris asked:
|||
|||| Hello, I was wondering if there is a way to do a bulk extraction of
|||| 30 calendars in MS Outlook to a form that can be used in MS Access?
||||
|||| I know about exmerge but it only extracts to a pst file but is
|||| there a way to use that pst file in MS Access?
||||
|||| Thanks for your help.
 
We are using Outlook XP with Exchange 2000. We do know that Access would
help but the person who would need this info, I think, doesn't really know
access. She needs to be able to generate those reports pretty easily. I
guess the main thing is the extraction of multiple calendars with ownership
to a format other than PST.
 
Back
Top