I have some mdb databases with the same structure and different data. I did a loop to do the same query in all those databases usign Querytable. 
The first issue is this code creates a new Querytable for each mdb (I delete it after the loop but I don't know if there is a better way to do that).
The second issue is that all the information should be datasource for a pivot table. When I run the code below, I have an error because "I'm trying to overwrite a pivot table"

Could you help me, please? What I really need to do is execute the same query in some mdb files and put data together as one pivot table

```
For i = 1 To UBound(strPath)
varConn = "ODBC;DBQ=" + strPath(i) + ";Driver={Microsoft Access Driver (*.mdb)}"
With Worksheets(wksDestino).QueryTables.Add(Connection:=varConn, Destination:=Worksheets(wksDestino).Cells(iLastRow, 1))
    .FieldNames = bHeader
    .CommandText = varSQL
    .RefreshStyle = xlOverwriteCells
    .Refresh BackgroundQuery:=True
    .PreserveColumnInfo = True
    .AdjustColumnWidth = bHeader
End With
iLastRow = Worksheets(wksDestino).Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1
bHeader = False
Next i

```

The problem is this is datasource for a pivot table