how to close down a query

When I write the code for a query using adodb I can clear it after use by using something like

Set Newrst = Nothing

I have been working with Sage Line100 which does not seem happy with recordsets and have therefore used ODBC and Querytables instead.
Can any one help me with shutting down such a query. Code such as

Set Sageqt = nothing

Although it does not cause an error, does not work so the number of named corrections grows as the application is used.
What should I using to clear the query after it has been used

Norie, this is what I have been trying

Sub DownLoad(SheetName, SQLStr)
Sheets(SheetName).Visible = True
Const SAGECONN1 As String = "ODBC;DSN=WindmillSage;UID=test;;"
Dim qtSage As QueryTable
Dim rngDest As Range

       Set rngDest = Sheets(SheetName).Range("A8")
        Set qtSage = Worksheets(SheetName).QueryTables.Add(SAGECONN1, rngDest, SQLStr)
          qtSage.RefreshStyle = xlOverwriteCells
          
          qtSage.Refresh False
          Set qtSage = Nothing
          
          Set rngDest = Nothing
'ActiveWorkbook.Connections("Connection").Delete

End Sub