How to use varibles in a excel to look up information in access

[HeyHey89]

This is what I have ( it is just the SQL part of the VBA). I woud l like to be able to Look up all my values in Column A in Access database and return additional information how would I do that?
Set db = OpenDatabase(Dbloc)
SQL = SQL & "SELECT Date" & " "
SQL = SQL & "FROM " & " Deduction" & " "
SQL = SQL & "WHERE Payment = '6754238' "
Set rs = db.OpenRecordset (SQL, dbOpenSnapshot)

 

[shg]

Duplicate post: https://www.mrexcel.com/forum/excel...l-look-up-information-access.html#post5109530