Excel 2013 - Macro to update new sheet

Hi All,

Really new to excel VBA and I'm looking for some help.

I've got a spreadsheet that pulls data from a SQL server.

I'm looking to have a button on the first sheet that extracts the data from SQL and inserts it into sheet 2 of spreadsheet.
The data connection from SqL is working fine but when I click on the button sheet 2 is blank.

Any ideas...

I found this

Sub AllStaff()

Dim conString As String
conString = GetTestConnectionString()

Dim query As String
query = AllStaffquery()

Dim target As Range
Set target = Sheets(2).Cells(30, 1)

Select Case ImportSQLtoQueryTable(conString, query, target)
Case Else
End Select

End Sub

but this doesn't work