This all can be done without CF and CF is not a good solution when importing large csv files. Use BCP in sql server.
-----Original Message----- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 12:36 PM To: CF-Talk Subject: appending two queries Let's say that I have a CSV file that I am reading into a page, and I convert it to a query. I have a database table that it set up exactly like the converted query, I want to basically insert the CSV data into the database. Is there an easier, more efficient way to do this that looping over the CSV query and doing an insert for each record? SQL Server 2K, CFMX6.1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244584 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
