An easier way to insert data from Query Object intodatabase?

[Tomdogggg]

I'm currently using CFHTTP to get a CSV file and convert it into a QUERY
OBJECT. I want to take this query object and insert it into a DATASOURCE I
have setup on my server. Currently, I have to use CFLOOP to go through each
record; but there are 100,000 records!!! The operation is timing-out on me,
not to mention the obvious, taking FOREVER to do. Is there anyway to insert
ALL of the records from this QUERY OBJECT, into my DATASOURCE and do it with
less stress on COLDFUSION, and much more on the DATABASE(I don't want to use
CFLOOP)?

[Stressed_Simon]

What database?

[Tomdogggg]

an MSACCESS database

[Tomdogggg]

I guess an idea I'm trying to get at is in the SQL statement, is there anyway I
can do this:

<cfquery datasouce="ds">
SELECT COLUMN_1,COLUMN_2,COLUMN_3
INTO DATABASE_TABLE
FROM QUERYOBJECT.THEQUERY
</cfquery>

Basically, I guess I'm trying to access 2 datasources in the same query.

[mattw]

If this doesn't have to be automated. Just use MSAccess to import the file.
Don't even bother with CF.

Otherwise, cfloop is pretty much your only choice. You could break it up
somehow such as sorting on an ID column, running the first 10,000 records, then
the next 10,000. I'm not sure exactly how to do this, but there should be a way
(maybe use cflocation after the cfloop and pass in the ID number to start with).

[mxstu]

Tomdogggg,

I agree with mattw. If this is a one time import, just do it directly in
Access. If not, then it may be possible to import a csv file into Access using
cfquery but without looping. Given the amount of data you're importing, I
don't know that it is the best solution, but I believe it is possible.