Posted on 2011-04-20
Last Modified: 2012-08-14
Access database to thew previous message
Question by:99Boot99
    LVL 47

    Accepted Solution

    Not really sure what you are asking here or what you want to acheive
    However, if you are looking to import data from Access DB into Outlook
    The easiest way is to consider the data you want to export/import

    Then go into outlook'
    Go to a similar item in OUtlook you would lile to import
    ie, if you want to import Access Contacts into Outlook contacts, go to contacts
    In outlook use Imprt/Export Option
    Choose Export to File
    Choose Access DB

    This will then create a access db file of contacts

    If you open this in access you can see how outlook formats the contacts in access.

    The access DB you want to import into outlook will need to conform to this same format

    ONce you have done that, your Access DB will be fine to import into outlook without any issues

    Author Closing Comment

    It's not as simple as that.  The headers in Access have to match exactly to  those in Outlook.  The problem lies in to fact that an .accdb file  has to be converted to text before  it's imported to a Outlook .pst file.

    If  you'll look at the Experts Exchange Knowledge Base  there is confusion on how this can be accomplished efficiently  & quickly.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Use email signature images to promote corporate certifications and industry awards.
    Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    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 …

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now