VBA: Create table from Pass Through Query

[Marcster]

I'm trying to see if it's possible to automate the following via VBA:

Create a SQL Pass Through Query to SQL Server
Create a table (Or insert to a blank pre setup table) from the results of running the above query
Delete the created SQL Pass Through Query
Save the table

Has anybody tried coding this before?

http://office.microsoft.com/en-us/access/HP051880531033.aspx

http://support.microsoft.com/kb/304323