Import data from access to lotus address book

Posted on 2005-05-12
Last Modified: 2013-12-18

I liked to know how import name and email from access request to address book in lotus note? Could I import from an excel file to lotus note? (name and email)

Thanks a lot

Mrs Bonds
Question by:Mr_Bonds
    LVL 46

    Expert Comment

    by:Sjef Bosman
    A direct import from eExcel isn't possible, but you could save the file from Excel in a Lotus123-format, with extension .wk4. That file will be readable by Notes. In my experience, I mostly used this type of inport. The first row is to contain the names of the fields where the data is to be stored, the other rows contain the data. Then it's just File/Import, select the correct type and file, and start. Suggestion: try this first on a test database. For what address book do you want to do this? I hope not the server's NAB...

    You can also write some functionality in Access, using VBA to connect to Notes. That's a whole lot more work, though.
    LVL 31

    Expert Comment

    Get NotesSQL, which allows Access to read from/write to Notes.  You will then be able to have Access push the ocntacts to Notes.

    Or do the reverse -- if you can program in Notes, you can have Notes do SQL queries via ODBC against the Acess data.

    However, there isa a big problem with either of the above.  The data mapping is very difficult.  The same sort of problem would occur if the data was in Excel, 1-2-3, or any other basic data file format.

    So, let me suggest a different way.  Notes has facilities for turning VCF into contacts.  If you can get the Access data into VCF, then Notes can import it directly.
    LVL 31

    Accepted Solution


    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.

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now