Re: Strip inbox details and populate db

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ken Slovak - [MVP - Outlook] (kenslovak_at_mvps.org)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 09:42:50 -0500

Easy enough to do using ADO code. Attachments can only be accessed by saving
them to the file system and then opening the files using something like
Windows Scripting's FileSystemObject. If you are using code for the Access
tests it would be very similar, just a different connection to the SQL
server. If you are using Access linked tables there is no corresponding
linkage to SQL server tables so you have to start coding from scratch.

See http://www.outlookcode.com/d/database.htm#ado for information to get you
started using ADO code with your Outlook data. 

-- 
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm
"Mark Lux" <anonymous@discussions.microsoft.com> wrote in message
news:115b001c4102f$9b179da0$a501280a@phx.gbl...
> Hi,
>
> I need to strip off all info from messages received into
> outlooks inbox as well as any attachments.  This
> information needs to populate an sql table running on an
> sql 2000 server on a remote machine...
>
> Can anyone point me in the right direction, i've done a
> few tests with msaccess, and yeh i can get all the data i
> need (except for attachments) but i need to get the info
> into sql and not access...and i have no idea?
>
> Thanks in advance..
>
> Mark

Relevant Pages

  • Re: Why wont this work in a update query
    ... If [Attachments] is a Text Field, the first argument of the IIf is incorrect ... Either way (Text or Boolean Field), you will have errorwith the Update ... SQL due to data type mismatch! ... filed not a Y/N datatype ...
    (microsoft.public.access.queries)
  • Re: UPDATE QUERY PLEASE HELP!
    ... I explained the problem with the Update SQL in the orginal thread: ... doing a Boolean-value comparison on the Field and then ... The Field [Attachments] canNOT be ... In the Select SQL, the IIf expression is a Calculated Value only (not being ...
    (microsoft.public.access.queries)
  • Multiple tables refer to one -To use foreign keys or not?
    ... As one of my first encounters with SQL, ... To be able to relate each object to its eventual attachments, ... colleague felt that too many fields would remain empty with the first ... against it when the rest of the design does not. ...
    (comp.databases.theory)
  • Get attachments during an asynch OnSave event
    ... Information about it is placed into a SQL db ... The code is attached to an asynch onSave event. ... I can see if there are attachments by checking oRecord.Fields[ ... ADODB.Record oRecord = pNewEventInfo.EventRecord; ...
    (microsoft.public.exchange.development)
  • RE: SQL Codeing behind a PivotTable
    ... Should I amend the SQL statement at MSQuery for pivottable? ... But it works if I amend the SQL statement at ADO code. ...
    (microsoft.public.excel.programming)