Strip inbox details and populate db

  • Thread starter Thread starter Mark Lux
  • Start date Start date
M

Mark Lux

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
 
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.
 
Back
Top