[AccessD] Making a table from a recordset

Making a table from a recordsetSELECT *|fldlist INTO newtable
FROM table
WHERE condition

if you're creating a new table

INSERT INTO targettable
SELECT *|fldlist
FROM table

if you're appending to an existing table. INSERT INTO has some quirks and can be difficult to use. 

strSQL = "SQLstatement"
cnn.Execute strSQL

Now, if this is really a connection question -- as to what type of connection you should use????? 

Susan H. 

What is the quickest way to copy data into a table, from a recordset with a connection other than the current project.  
  Pretty sure the way I'm doing it is not the fastest, and was hoping to save some time.

  TIA

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030424/74b7c39b/attachment-0001.html>