[AccessD] Create Temp Table from Recordset

Vlad,
 
I've not tried it but you might look at creating a make table query in the
Query designer, then look at the SQL statement it produces.  Instead of
running "with rst..." just do a "docmd.runsql 'SQL Statement here'"
 
HTH
 
Rusty
 
 
-----Original Message-----
From: ACTEBS [mailto:actebs at actebs.com.au]
Sent: Monday, June 09, 2003 9:48 AM
To: access group
Subject: [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/20030609/46c9fb3c/attachment-0001.html>