Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-08-24 : 11:44:41
|
| Hello All,I'm trying to get email information to my sql server 2005 db. There are two ways to retrieve the email information:- via webmail- via OutlookMy question is how would I connect to either the webmail method or the Outlook method to my sql server 2005. Once connected I want the data to be in an xml format, which would make it easier to parse out the data. My version of Outlook is 2003Any advice would be appreciated. Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-24 : 12:20:29
|
| create a .net program that uses Outlook interop COM object and also connects to the sql server database.in there read stuff from outlook and insert it into sql server.use google for some code examples._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
|
|
|
How to insert an xml file to db automatically?