xsinner
asked on
Automatic exporting meetings from Exchange to Access database
Hello,
I know very little ASP. I am trying to create a script which will export
meeting requests from the Exchange server to an Access database automatically on a
daily basis. The meeting requests contain data such as Subject, Location, Start Time, and End Time.
These data will sort into a database table in Access which contains fields with the same categories
during the exporting.
I'm trying to connect remotely from one server that has Access
to the Exchange server. We are using Exchange 2000 and Access 2000. I have
not found any sample codes or illustrations on how to do this. Could someone
point me to the right direction? Thank you very much.
I know very little ASP. I am trying to create a script which will export
meeting requests from the Exchange server to an Access database automatically on a
daily basis. The meeting requests contain data such as Subject, Location, Start Time, and End Time.
These data will sort into a database table in Access which contains fields with the same categories
during the exporting.
I'm trying to connect remotely from one server that has Access
to the Exchange server. We are using Exchange 2000 and Access 2000. I have
not found any sample codes or illustrations on how to do this. Could someone
point me to the right direction? Thank you very much.
I haven't seen anything to do that for Exchange.
There isn't really any interface at the Exchange server level which you could use. The main interface is MAPI clients which is Outlook.
For guidance on the points system, see the help pages: https://www.experts-exchange.com/help.jsp
Simon.
There isn't really any interface at the Exchange server level which you could use. The main interface is MAPI clients which is Outlook.
For guidance on the points system, see the help pages: https://www.experts-exchange.com/help.jsp
Simon.
ASKER
If that's the case, could you point me to instructions or sample codes which I can automatically export meeting requests
in Outlook to an Access database? Thanks.
in Outlook to an Access database? Thanks.
This is Microsoft's sample for Contacts.
http://support.microsoft.com/?kbid=290792
It would be very similar for Calendar, as long the default calendar folder is being used.
Simon.
http://support.microsoft.com/?kbid=290792
It would be very similar for Calendar, as long the default calendar folder is being used.
Simon.
ASKER
Thanks for the link. I was experimenting with simple manual importing from Exchange/Outlook into an Access table. The results were little different from what I was expecting. I thought I would see the meeting dates and meeting times in the database. Rather, I was seeing the creation dates and modify dates. I assume I would get the same results even if I were to export programatically?
I would guess so. I have never done it.
Simon.
Simon.
ASKER
Does anybody else know of a way to export programatically meetings (containing appointment dates and times) to an Access database? I read on the Internet somewhere about utilizing webdav. Would webdav be a solution? Thanks.
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You'll probably want to use CDO to talk to Exchange. Have a look through some of Glen Scales samples: http://gsexdev.blogspot.com/2004/08/vcalendar-with-cdo-and-script.html
Kris.
Kris.
ASKER
Just want to let everybody know that I have not abandoned this issue. I am testing out your suggestions. I will get back to you asap. Thanks.
ASKER
The Symprex Connector worked out fine. Thanks for the recommendation.
ASKER