How to set the correct SQL syntax to use WHERE?

[Fractalis]

Hello everybody in forum,

I've found the example code of how to use SQL in VBA in here query-table-with-excel-as-data-source.html (See Code below)

All the code works fine, but my issue is how to set the correct query to
print print Field2, Field3 where Field1 = 2008.

If I use below line works but prints all lines:

SQL = "SELECT [Name],[LastName] FROM [Employees$A2:P6]"

If I use below line, I get Run Time Error saying something like: "Some values haven't been established for some required parameters"

SQL = "SELECT [Name],[LastName] FROM [Employees$A2:D6] WHERE [Year]=2008"

If I use below line, I get Run Time Error too with the same error.

SQL = "SELECT [F2],[F3] FROM [Employees$A2:D6] WHERE [F1]=2008"

How would be the correct syntax in order to be able to use WHERE?

Sub Excel_QueryTable()
Dim oCn As ADODB.Connection
Dim oRS As ADODB.Recordset
Dim ConnString As String
Dim SQL As String
Dim SourceFile As String
Dim qt As QueryTable

SourceFile = Application.ThisWorkbook.FullName
                     
ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
                  "Data Source=" & SourceFile & ";" & _
                  "Extended Properties=Excel 12.0;" & _
                  "Persist Security Info=False"
                  
Set oCn = New ADODB.Connection
oCn.ConnectionString = ConnString
oCn.Open

[COLOR=#0000cd]SQL = "SELECT [Name],[LastName] FROM [Employees$A6:P250]"[/COLOR] [COLOR=#008000]'Here is the line where I need help[/COLOR]

Set oRS = New ADODB.Recordset
oRS.Source = SQL
oRS.ActiveConnection = oCn
oRS.Open

Set qt = Worksheets("Dest").QueryTables.Add(Connection:=oRS, _
Destination:=Range("B2"))

qt.Refresh

If oRS.State <> adStateClosed Then
oRS.Close
End If

If Not oRS Is Nothing Then Set oRS = Nothing
If Not oCn Is Nothing Then Set oCn = Nothing

End Sub

The sample database in sheet Employees is:

Year	Name	LastName	Department
2003	Mary	J.	Sales
2007	John	K.	Adminstration
2008	Carl	M.	accounting
2010	Ann	P.	Security
2008	Peter	T.	Restaurant

<tbody>
</tbody>

Thanks for any help.