The best way to find the code for you to use is to record a macro while
manually performing a query from Excel using MSQuery (Data/Get External
Data/New Database Query)

HTH, Greg

"pcw" wrote in message
...

Is it possible to incorporate SQL with VBA Excel code?