Home Forums SQL Server 7,2000 General Directly importing data from an email RE: Directly importing data from an email

  • June 27, 2003 at 6:40 am

    #463434

    Hi roadrunner,

    quote:

    Is there a way to import data directly from an MS Outlook email into a SQL2000 table without exporting the data to a text file first?

    several ways to do this without flatfiles.

    • i guess most easy is using the Exchange ODBC? Driver from M$, but I don't know if it's still available from their site. Maybe you have to put Access in between. but it works!
    • use VB with references to CDO or Outlook Object Library

    If you decide to go way 2, post again. I can give you some snippets

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]