I am trying to figure out how to update a sql table using a CSV file that has commas in the data fields. The long and Short of it, is that we have a SEO company rewriting our keywords, meta descriptions and titles for our product database. We were able to build a simple CSV export so that they could add the new info. Now we need a way to import it back into the systm and update all of the records based on the productID, wich is in the csv file.
The developer we are using says it can be done, but we cannot have commas in any of the fields. We can wrap the columns in double quotes on an export, cant we do this on the import? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
