Run-time error '3125' invalid punctuation because fieldname contains

I try to transfer PO data from SQL Server into my MS Access
Application.

The following SQL works fine:
SELECT * INTO purchase_headers FROM [ODBC;DRIVER=SQL
Server;SERVER=MYSERVER;APP=2007 Microsoft Office
system;DATABASE=MYDB;UID=myuid;PWD=xxxxx].[PO]

As soon as I add a where clause an error appears
SELECT * INTO purchase_headers FROM [ODBC;DRIVER=SQL
Server;SERVER=MYSERVER;APP=2007 Microsoft Office
system;DATABASE=MYDB;UID=myuid;PWD=xxxxx].[PO] WHERE [Job No.] = '999'

Unfortunately the field Job No. can not be changed in my SQL Server
database