Importing Exchange Messages

[Guest]

I would like to be able to import Outlook messages into an Access data base
and bring along any/all attachments.

My organization has tens of thousands of messages that we archive into
various unique .pst files. The messages may have .doc, .xls, .txt and .html
documents attached to them.

We could save hundreds of hours of searching if we could create an archive
database that included each message along with the associated attachments.

How can this be accomplished? I am running Outlook 2002 and Access 2002.

Your help would be appreciated.

 

[John Nurick]

Hi Richard,

Access isn't a great tool for this sort of job. It's a relational
database designed primarily for handling rigidly structured data, not
for dealing with large amounts of text and binary (e.g. .doc, .xls)
files.

It would be possible to build the system you envisage using Access, but
IMHO it would make much more sense to use an application that can index
the PST files as they stand. The names ISYS, Copernic and AskSam come to
mind, though I'm not certain that all these can get inside attachments
inside PSTs.