Importing Exchange Messages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RichardSbC - 23 Nov 2004 16:37 GMT

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.

Reply to this Message

John Nurick - 23 Nov 2004 22:13 GMT

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.

>I would like to be able to import Outlook messages into an Access data base
>and bring along any/all attachments.
[quoted text clipped - 9 lines]
>
>Your help would be appreciated.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message