I'm not sure what your "main" database is, but standard SQL supports an
Insert Into Select From statement. In Access the query would look like:
INSERT INTO Table1 ( Field1, Field2 )
SELECT Field1, Field2
FROM Table2
Of course, your SELECT statement can include a WHERE clause to choose the
proper records, etc.
Bob
-----Original Message-----
From: Joseph Vincent [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 4:27 PM
To: CF-Talk
Subject: Insert Statement
I am running a query that selects 49,000 records from our main
database...then I'm turning right around and inserting these records into an
Access database for another use. The problem is that this takes FOREVER!!
(about 10-12 minutes). When I insert the records I am looping with the
<CFOUTPUT query = "1st query"> tag and using INSERT INTO for each iteration
of the loop. I'm just wondering if there is anyway to insert all of the
records I selected in the 1st query at one time?
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
