excel 2000, vba and msquery(sql)

  • Thread starter Thread starter pmz
  • Start date Start date
P

pmz

Is there any way to use additional key words (such as
between and in) when using a macro to pull in external
data? So much extra coding to put arguments in
separately. Thanks.
 
pmz

You can use In (and I assume between) in your SQL statement in MSQuery. If
you want to use parameters as the arguments for In or Between, then I don't
think it's possible - at least not that I've seen.
 
Back
Top