[AccessD] Create Temp Table from Recordset

Guys,
 
Is there a method of creating a temp table in your DB from a recordset?
eg:
 
dim strSQL as string
dim db as dao.database
dim rst as dao.recordset
 
strSQL = "SELECT someTable etc etc etc"
 
set db = opendatabase("some remote DB")
set rst =db.openrecordset(strsql)
 
with rst
    make a new table in my db from the recordset
end with
 
I've never had to do this and have wasted heaps of time on this. Any
help will be much appreciated...
 
Thanks
Vlad
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030610/b1265135/attachment.html>