ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Microsoft Query - Entering Column Names with Blanks (https://www.excelbanter.com/excel-discussion-misc-queries/168641-microsoft-query-entering-column-names-blanks.html)

Robert Meade

Microsoft Query - Entering Column Names with Blanks
 
I have used Microsoft Query with Excel 2003 for some time now, and
until today I have been able to enter columns names with blanks in
them using [ ]'s.
For instance:
Select [First Name], [Favorite Food]
from master..foodtable

I get an "Incorrect Syntax Near Food" error, and the help is helpless
in this case.
Is anyone aware of some security "fix" that might be causing this
problem - I cannot edit existing queries.
Thanks!
Robert


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com