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)

 

[ranman256]

SQL= "select * from Deduction where payment ='" & range("a1").value & "'"

 

[HeyHey89]

but what if I want to look up all the values in column A?