Exporting my Outlook contacts into an Access database

Posted on 2005-04-14
Last Modified: 2010-04-08
Hi there,

Does anyone know if there is a way of exporting Outlook contacts (Outlook 2003) into an Access 2003 database?

I have hundreds of contacts in my Outlook and have a database set up with the usual Title/First Name/Address1/Address2/ fields etc...

How could I export my contacts from outlook and then easily get them into the database?

Many thanks!
Question by:gjirvine3000
    LVL 11

    Accepted Solution


    I would do this by exporting contacts from outlook into a .csv file, then using that .csv file to import into access.

    If you need help going through this pls give me a shout!!


    LVL 76

    Expert Comment

    by:David Lee
    Hi gjirvine3000,

    Yes, it's definitely possible.  The absolute easiest way to do this is to use the Export feature built into Outlook (File -> Import & Export).  There's also a feature (File->External Data->Import) built into Access 2002/2003 (not sure about earlier versions) that'll read Outlook directly.  However, it suffers from a shortcoming of only handling certain contact fields.  If neither of these are suitable solutions, then it's easy enough to write some code in either Outlook or Access that'll read your contacts and copy them into an Access database.  

    LVL 17

    Expert Comment

    Both the answers above will work fine, I prefer to use the Access feature of File - Get External data - Import  and then choose the data type to be Exchange().  I have found this to be the quickest way to import from outlook to access

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
    Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    758 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

    12 Experts available now in Live!

    Get 1:1 Help Now