Access and Excel help
I’m currently using vba in access to export values to an Excel Spreadsheet. I have this query below but I cant seem to export the value the SQL statement gives to the correct field in the spreadsheet.
n = 2
temp01 = xlSheet.Range("F" & n).Value
temp02 = xlSheet.Range("B" & n).Value
sql1 = "Select IFF_name from IFF_Descriptions Where IFF_Description = “ & temp02
temp01 = sql1