This will happen once a day, every day. Same data structure, yes, same database table, yes. Same data, no.
Ben Nadel wrote: > 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:244569 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
