> Let me bring a little more background in to the equation. The data that > is being read in via CSV has a date attached to each record, if any of > the dates in the database matches those dates, I need to delete any and > all data from that day, then do the group import, if possible. So, I > don't see any way to do this without CF getting involved. >
Whichever method you use for getting the data into SQL, it is probably best to put the data into a "holding" table and then do your comparisons, deletes and inserts all within SQL. In that case, the import logic could be encapsulated in a stored procedure, and the entire process could be handled in DTS (or as a pretty simple cfquery if using bulk insert). -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244579 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
