Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    connect to LDAP via Excel (Excel 2000)

    I got a request from a user who I did an Excel app for and he's wondering if I could enhance it to directly transfer data to an LDAP server. (Right now the Excel app puts data in a specific format in the clipboard so the user can paste it manually into another application.)

    The only thing I know about LDAP is what the acronym stands for but I do know how to use ADO to connect to a regular database.

    I did a search on LDAP in the Lounge but only refernces to Access/Outlook/Exchange came up. Is there a method like ADO to connect to an LDAP server from w/in Excel? <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    Please pass any tidbits of info my way.
    Thnx, Deb <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15>

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: connect to LDAP via Excel (Excel 2000)

    Okay, this is from the horse's mouth, so to speak:

    HOWTO: Use ADO to Access Objects Through an ADSI LDAP Provider (Q187529)

    It seems to be referring to the LDAP exposed through MS' Active Directory service, so if you use some other flavor of LDAP, it might not work.

    Digging deeper, it this looks pretty ugly: "The LDAP API documentation in the Platform SDK is intended for experienced C and C++ programmers and Internet directory developers. LDAP supports C and C++ programming languages. A solid understanding of directory services and the LDAP Client/Server Model is necessary for the developmental use of the LDAP API."
    Lightweight Directory Access Protocol API
    Using Lightweight Directory Access Protocol

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    Atlanta, Georgia, USA
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: connect to LDAP via Excel (Excel 2000)

    hyperlinks added- Mod

    I've also used ADO to access LDAP. Microsoft has an SDK that can be found here: http://www.vbdiamond.com/Sources/ViewSource.asp?ID=1182
    After installing, navigate down to the adsi/sdk/Samples/vbs directory. There are several samples there that, in my case, ALMOST work. I had to tweak them, but the tweaks were minor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •