excel 2000, vba and msquery(sql)

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.
 
D

Dick Kusleika

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Grouping Names in Mail Merge 0
Consolidation Table from Different Excel Tabs with Different Format 1
Excel-MSQuery Out Of Memory error 0
SQL ODBC MSQuery in EXCEL 1
filter on excel table with msquery and replaced header 1
Embed the same Excel multiple times 0
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0

Top