I found some code at http://www.mrexcel.com/archive2/51100/59373.htm

but now it is spitting out an error with regards to Nz() function!  The
query runs fine.  I know this for a fact.  I also know that Excel doesn't
handle Nz().  This said, the query does not have Nz() in it but does join to
another query that does use it.  That is why I couldn't use it in a standard
Data import and why I need to run the query through vba.  But it seems as
though excel will only run queries that it can handle through the Data wizard
which defies the purpose of running the query through vba.  I hope this made
some sense.

I must say it is increadibly difficult to transfer data between applications
when functionalities are not supported trhoughout the suite of office
applications, especially a commonly used function as Nz(). -- just my opinion.

QB