October 13, 2003 at 12:31 am
Hi All,
Is it possible to transfer data from MSSQL2000 to Exchange2000?
I will appreciate for any ideas.
October 13, 2003 at 4:06 am
Transfer how? Where would you put it in Exchange?
Andy
October 13, 2003 at 4:20 am
Hi Knpo,
quote:
Is it possible to transfer data from MSSQL2000 to Exchange2000?
take a look in BOL for 'Exchange'.
Is this going into your direction?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 13, 2003 at 5:02 pm
Tank you fo reply.
I need to transfer data (address, phone number, email etc) from "Master" MSSQL200 database to Exchange, so user can use it in Outlook.
It wiil be good to use DTS packages.
October 14, 2003 at 12:53 am
Hi,
I transfered data from a SQL Server to an Exchange server by exporting the table to Excel an then I wrote a VBA script in Outlook to import the fields into a contact.
It is also possible to write data directly into a Exchange database using MS Access.
Matthias
October 14, 2003 at 1:00 am
quote:
I need to transfer data (address, phone number, email etc) from "Master" MSSQL200 database to Exchange, so user can use it in Outlook.It wiil be good to use DTS packages.
in addition to what Matthias suggested you might want to take a look at
http://www.cdolive.com/start.htm
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 15, 2003 at 12:51 am
Thanks.
Matthias could you please give more details of using Access or give a sample of VB code.
October 15, 2003 at 3:05 am
quote:
Matthias could you please give more details of using Access or give a sample of VB code.
This search on knowledge base should give you a lot of examples
http://support.microsoft.com/default.aspx?scid=kb;en-us;171671&Product=cdo is also useful as it shows how to add something into Exchange Server. in this example it is a mail, but it could also be anything else.
However, first you need to get familiar with the CDO object model, that's why I posted the link to cdolive.com
HTH
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply