connect to LDAP via Excel (Excel 2000)

Topic

New Reply

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?

Please pass any tidbits of info my way.
Thnx, Deb

Reply | Quote

Replies

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

Reply | Quote

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%5B/url%5D
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.

Reply | Quote