<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Making a table from a recordset</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>SELECT *|fldlist INTO newtable</FONT></DIV>
<DIV><FONT face=Arial size=2>FROM table</FONT></DIV>
<DIV><FONT face=Arial size=2>WHERE condition</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>if you're creating a new table</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>INSERT INTO targettable</FONT></DIV>
<DIV><FONT face=Arial size=2>SELECT *|fldlist</FONT></DIV>
<DIV><FONT face=Arial size=2>FROM table</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>if you're appending to an existing table. INSERT
INTO has some quirks and can be difficult to use. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>strSQL = "SQLstatement"</FONT></DIV>
<DIV><FONT face=Arial size=2>cnn.Execute strSQL</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Now, if this is really a connection question -- as
to what type of connection you should use????? </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><FONT face=Arial color=#000000 size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#000000 size=2>What is the quickest way to</FONT>
<FONT face=Arial color=#000000 size=2>copy data into</FONT><FONT face=Arial
color=#000000 size=2> a table</FONT><FONT face=Arial color=#000000
size=2>,</FONT><FONT face=Arial color=#000000 size=2></FONT> <FONT face=Arial
color=#000000 size=2>from</FONT> <FONT face=Arial color=#000000 size=2>a
recordset</FONT><FONT face=Arial color=#000000 size=2> with a connection other
than the current project</FONT><FONT face=Arial color=#000000
size=2>. </FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<P align=left><FONT face=Arial color=#000000 size=2>Pretty sure the way
I</FONT><FONT face=Arial color=#000000 size=2>'m doing it is not the fastest,
and was hoping to save some time.</FONT></P>
<P align=left><FONT face=Arial color=#000000
size=2>TIA</FONT></P></BLOCKQUOTE></BODY></HTML>