MS Query SQL parsing is buggy

External Since: Apr 02, 2004 Posts: 1

I find that any time I use "in" as a criterion, as in "in ('a','b','c')", MS Query will allow it just fine for the current session, and I can switch back and forth between Query and SQL views without problems. But when I save the query and then reload it, it comes up in SQL mode, and claims "illegal SQL syntax" when I try to go into Query mode. Note that this is SQL that it has created!

Can anyone guess if this is likely to be fixed in Excel 2004?

External Since: Nov 22, 2003 Posts: 229

Hi,

Can you paste into a message in this thread the exact query that is failing.
Maybe we can try a different syntax.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
<a style='text-decoration: underline;' href="http://www.mvps.org/" target="_blank">http://www.mvps.org/</a>

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

----------
In article , "Peter"
wrote:

>
> I find that any time I use "in" as a criterion, as in "in ('a','b','c')",
> MS Query will allow it just fine for the current session, and I can switch
> back and forth between Query and SQL views without problems. But when I
> save the query and then reload it, it comes up in SQL mode, and claims
> "illegal SQL syntax" when I try to go into Query mode. Note that this is
> SQL that it has created!
>
> Can anyone guess if this is likely to be fixed in Excel 2004?