March 19, 2008 at 5:10 am
Hi All
I need to import all my E-mails(Outlook) into a table, is there any ways to do this on SQL,
(The main reason to set this is for alerting system, once i have imported it into database i can send a sms alert from our systems,)
is there any free tool i can use, or is there any option on SQL 2005 to read the mail and insert it into database if it is from a particular user
Please advice me on this
Thanks
Suji
March 19, 2008 at 5:27 am
It looks like you can export emails to a file out of outlook into access/excel (admittedly folder by folder) - and then import as normal.
Alternatively, I believe you can connect to Exchange through ODBC/OLE DB.
March 19, 2008 at 5:36 am
You could use xp_readmail to read mail from the SQL Mail box. However this is being deprecated in a future version of SQL Server.
That said, it looks like an alternative might be included in SQL Server 2008 - http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126167
There are some third party tools that can do this for you - I should know, I used one a few years ago but I can't remember what it was called. If I find it I'll let you know.
March 19, 2008 at 5:37 am
Thanks Karl ,please let me know 🙂
March 19, 2008 at 5:39 am
Hi Peter,
Thanks, i tried to import via import wizard, but when i choosed OLE DB outlook search, and on properties, all my fields are disables except datasource, i cant go beyond that step, do i have to enable any advenced configuration for this??
Cheers
Suji
March 19, 2008 at 7:47 am
Some points of interest here maybe - connecting to Outlook via LINQ or ADO/DAO
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply