Thanks Ben, I'll give the UDF a thorough run through and see what happens. I'm still pretty keen to work on a solution using a stored proc to take the weight off of CF as it'll be busy on other things, but this will at least help me get my head into CSV's.
Rob -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 16 April 2007 14:03 To: CF-Talk Subject: RE: Parsing CSV Rob, While I cannot offer any "advice" on DTS or which is best (as my experience with CSV is very limited when it comes to real-world applications). However, if you are interested, a while back I wrote a UDF for parsing a CSV data chunk into a ColdFusion query. It can handle qualified fields as well as embedded delimiters and qualifiers: http://bennadel.com/blog/501-Parsing-CSV-Values-In-To-A-ColdFusion-Query ...htm Or: http://bennadel.com/index.cfm?dax=blog:501.view ....................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 8:53 AM To: CF-Talk Subject: Parsing CSV Hello Guys, I'm looking to get some advice on the best method to parse a CSV into my SQL Server 2k5 database. The idea is that the data will be passed in as a string to a web service. In the past I've spoken to people who seem to think that the DTS is the best method for getting the text into the database but to be honest it seems less fitting now the data is passed into a web service, by the time the server has placed it into a file and then DTS has auctioned it, I may as well use a Query or a StoredProc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
