Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is microsoft query? | Excel Discussion (Misc queries) | |||
Show Non Blanks using MS Query | Excel Discussion (Misc queries) | |||
Microsoft Query | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Microsoft Query | Excel Discussion (Misc queries) |