execute a make table query in an access database

[Question Boy]

The basic idea:
I need to run an existing make table query in a database without the user's
intervention. I have tried some code I have found online but none work (thus
far).

The complete picture:
Same as above, however, I would need to be able to pass along a user input.
In this case am I better executing an SQL statement from Excel to Acces? If
so, how?

Could someone point me in the right direction.

Thank you,

QB

 

[Question Boy]

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