SQL Intergrated With VBA

Hi, i've searched the forums, no look with this one im afraid.

What i want is when a button is pressed, i want the following to happen:


I want a new blank table to be created.

I want records from an SQL query to be added into the table.

I want to send that table to an external MS Access file.

I want the tempory table to be deleted.


I 've done a lot of reasearch into this, and i have found that the best way to do it is using an SQL statement, and then the DoCmd.RunSQL property.

But i cant figure out the sql code to do the above, can anyone give me some generic code that i can follow to help me?

Thanks!:D