Convert PST email to a searchable database

Posted on 2005-04-08
Last Modified: 2011-08-18
We need to have our email saved on CD in some sort of format that will allow searching using a variety of terms, such as by name, date, keyword.

Unfortunately, it can't be a PST file.  It has to be burned on a CD with some sort of reading and searching software included on the CD.

There is one other option. The files are also saved in a MS SQL database, if there is an easier way to use that.


Question by:computerlarry
    LVL 6

    Assisted Solution

    You can export your PST files into Excel.... Would that work for you?

    Author Comment

    When I try that, the text of the message body has lots of Invisible characters that show up as squares or other odd ascii graphics characters - many messages are formatted in Word, or HTML, so I'd like to avoid that if possible.

    Is there a file size limit in Excel 2003?  Or does the unicode compatibility enable files that are larger than 2G?

    The export gives me the thought of going into Filemaker Pro or Access. I could take advantage of better searching.
    LVL 15

    Accepted Solution

    You don't have an option to export from a .pst file to Filemaker Pro unless you use a third party format such as dbase or excel, but you can export directly to Microsoft Access from Outlook.  I can't tell you what the result will be, but I would expect it to be more workable than either .xls or .dbf would be.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
    This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now