feeding an comparison querytable vigilant memory

greetings,

the vba formula next emanate an comparison querytable vigilant arrangement starting range("d2"). specific castle aim operation immaterial.

my doubt -- illusory manually feed values an in-memory recordset, following have list review it? words, i wish mention list columns values vba, have database file.

public servant foo()

    low blah querytable
    low rngtarget range

    low strquery string

    strquery = "select * my_table"
    set rngtarget = range("d2")
    low qt querytable
    set qt = rngtarget.worksheet.querytables.add(connection:= _
        "odbc;driver=sql server;server=my_sql_server;app=my_app;trusted_connection=yes", destination:=rngtarget)

    qt
        .commandtext = strquery
        .fieldnames = true
        .rownumbers = false
        .filladjacentformulas = false
        .preserveformatting = true
        .refreshonfileopen = false
        .backgroundquery = false
        .name = "my_range_name"
        .maintainconnection = false
        .refreshstyle = xloverwritecells
        .savepassword = false
        .savedata = false
        .adjustcolumnwidth = false
        .refreshperiod = 0
        .preservecolumninfo = false
        .refresh backgroundquery:=false
   finish with

end sub