Exchange-SQL server connectivity

I am fairly new to both the technologies.
Scenario:
I have an Exchange server on one machine, with Outlook. I
am looking for a way to get the information from Exchange
servers (mainly public folders) to SQL-server that is
located on a different machine.
My problem is as follows:
a. I need to get data from Exchange to SQL-server, real
time.
I am going through a round-about way of getting this
information. I have created Linked tables in an Access
Database that exports the data to the SQL-server (on the
same machine). It is not real time.
I can not seem to see the Linked tables from Access
when I use DTS.
There has to be a better way to do this.
Please advise.
Deven
for real time, open the outlook to the mailbox, using Outlook VBA NewMessage
write code to the sql server. Just leave the outlook open.
"deven" <anonymous@.discussions.microsoft.com> wrote in message
news:7cfa01c43149$c84894b0$a001280a@.phx.gbl...
> I am fairly new to both the technologies.
> Scenario:
> I have an Exchange server on one machine, with Outlook. I
> am looking for a way to get the information from Exchange
> servers (mainly public folders) to SQL-server that is
> located on a different machine.
> My problem is as follows:
> a. I need to get data from Exchange to SQL-server, real
> time.
> I am going through a round-about way of getting this
> information. I have created Linked tables in an Access
> Database that exports the data to the SQL-server (on the
> same machine). It is not real time.
> I can not seem to see the Linked tables from Access
> when I use DTS.
> There has to be a better way to do this.
> Please advise.
> Deven
>