Directly importing data from an email

  • 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?

  • 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]

  • Thanks Frank, we are going to try the first option.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply