I have some emails (~1,500,000) that I need to throw into a SQL System
for some extensive analysis.

I know how to script a macro to traverse through all of the emails in
the system but I am wondering if there is a way to access ADO/ODBC of
any type from VBA in Outlook.

Any help is appreciated.

Thanks,

CJ

Just set a reference to the ADO of your choice in the Outlook VBA project
and use it all you want. I've used ODBC and ADO many times from Outlook VBA.
What you can't do is use an ADO or ODBC connection to Outlook and expect to
get anywhere near the actual number of properties that exist on an item, and
some properties (email addresses for one) are security restricted for ODBC
connections and not for native VBA Outlook object model code.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Curious Joe" wrote in message
...
I have some emails (~1,500,000) that I need to throw into a SQL System
for some extensive analysis.

I know how to script a macro to traverse through all of the emails in
the system but I am wondering if there is a way to access ADO/ODBC of
any type from VBA in Outlook.

Any help is appreciated.

Thanks,

CJ