Reading an XLSX and using a WHERE clause

All,

 

 

I'm attempting to issue a WHERE clause on reading an Excel file... but the source worksheet has column names that include spaces. So I can get this to work:

 

 

Test_me = 'Dave'

 

 

but this doesn't:

 

 

Test me = 'Dave'

 

 

and it returns a provider error:

 

 

Provider error `(-2147217900) Syntax error in GROUP BY clause.

 

 

I'm assuming its the space that is causing the issue, does anyone know of a work around, short of ensuring the source data has underscores instead?

 

 

Thanks