<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003>Vlad,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=356190015-09062003>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'"</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003>HTH</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003>Rusty</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=356190015-09062003></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> ACTEBS
[mailto:actebs@actebs.com.au]<BR><B>Sent:</B> Monday, June 09, 2003 9:48
AM<BR><B>To:</B> access group<BR><B>Subject:</B> [AccessD] Create Temp Table
from Recordset<BR><BR></FONT></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2>Guys,</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>Is there a method of
creating a temp table in your DB from a recordset? eg:</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>dim strSQL as
string</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>dim db as
dao.database</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>dim rst as
dao.recordset</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>strSQL = "SELECT
someTable etc etc etc"</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>set db =
opendatabase("some remote DB")</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>set rst
=db.openrecordset(strsql)</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>with
rst</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003> <FONT face=Arial
size=2>make a new table in my db from the recordset</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>end
with</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial size=2>I've never had to do
this and have wasted heaps of time on this. Any help will be much
appreciated...</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=876254314-09062003><FONT face=Arial
size=2>Vlad</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV></BODY></HTML>