Question

Reading an XLSX and using a WHERE clause

Forum|Forum|13 years ago
October 3, 2012
3 replies
53 views

+22

davideagle
Contributor

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.