Hi
I have a problem in excel when i try to import data from MSSql with
Import
external data: I must use the same condition in two places in the same
query..something like that:
select col2 from d where col1=? union select col3 from d where id not
in
(select col2 from d where col1=?)
this query works perfectly in MSSql, but when I try to do this in my
".dqy"
file the excel tell me I have an error in my sql...
pls help me
Michel Walsh - 25 Jul 2006 14:21 GMT
Hi,
It is probable that Excel context does not recognize the ? as a parameter.
Maybe preferable too to ask into an Excel newsgroup...?
Vanderghast, Access MVP
> Hi
>
[quoted text clipped - 12 lines]
>
> pls help me