[AccessD] Making a table from a recordset

---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 

"The information contained in this message (including any attachments) is
confidential in that it is intended solely for the use of the recipient to
which it is addressed. If you are not the intended recipient, the use of the
information by disclosure, copying or distribution is prohibited and may be
unlawful." 
---- End of Disclaimer ---- 

Thanks Susan,
 
That's helpful but it is more an issue of trying to insert records into a
local Access table from a recordset which has been created using a
connection to an Oracle database.
 
Any ideas?!
 
Thanks again,
RyanS
 
-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com]
Sent: 24 April 2003 16:39
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Making a table from a recordset
 
---- London Borough of Bromley Security Notice ---- 
"Please treat all e-mail with caution. Only open attachments from trusted
business sources whose material you are sure is safe. Refer to the Council's
e-mail and internet users Code of Conduct for further guidance on the
correct use of the e-mail system."
---- End of Notice ----
 
SELECT *|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/20030425/0456471d/attachment-0001.html>