DLookup - connect to db

[Stevenn]

I've tried to use DLookup in Excel, but how do I connect to my database before i use the function?

I've tried

Private Sub HentData()
    MsgBox Access.Application.DLookup("[Name]", "Persons", "[Id] = 2")
End Sub

but i guess it wont work before i choose which database i will use.

 

[CharlesChuckieCharles]

I see from earlier posts you've already been given the basics of connection to access from excel

Why don't you reuse that

 

[Stevenn]

I see from earlier posts you've already been given the basics of connection to access from excel

Why don't you reuse that

The DLookup function seems to be smarter when I just want 1 post based on an unique Id

I've tried to use basic access connection, but I can't use "WHERE Id = n LIMIT 1" in my SQL query

 

[CharlesChuckieCharles]

The D (Domain) functions in Excel are not the same as the D functions in Access

"WHERE Id = n LIMIT 1" in my SQL query

"WHERE Id = " & n & " LIMIT 1"