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:244565 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
