J
Jason Callas
I am trying to use Microsoft Query to get data from my SQL 2000 databases.
The problem is that I have a few columns with names that conflict with
keywords (like Identity). (Yes. I kow that keywords should be avoided but it
is done and cannot be changed.) This is causing a keyword syntax error
within the Query application.
Oddly enough, even if I do not select the column the error still appears.
And when you look at all the columns available, the keyword named column
shows up in boldface.
When I am doing queries in other programs I put square ("[ ]") brackets
around column and table names. This keeps the value from being treated as a
keyword.
The question I have is can this be done with Microsoft Query? Are there any
solutions (besides changing column names)?
The problem is that I have a few columns with names that conflict with
keywords (like Identity). (Yes. I kow that keywords should be avoided but it
is done and cannot be changed.) This is causing a keyword syntax error
within the Query application.
Oddly enough, even if I do not select the column the error still appears.
And when you look at all the columns available, the keyword named column
shows up in boldface.
When I am doing queries in other programs I put square ("[ ]") brackets
around column and table names. This keeps the value from being treated as a
keyword.
The question I have is can this be done with Microsoft Query? Are there any
solutions (besides changing column names)?