Is this a one-time deal? Or is this something you need to do on a regular basis (same DB, same table).
....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com "Some people call me the space cowboy. Some people call me the gangster of love." -----Original Message----- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 3: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:244566 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
