I've been lumped with a task that involves trasferring a fairly substantial volume of data from one DB to another (MS Sql to MySQL). Given the timeframe and my (limited) programming knowledge I'm using Excel to do the data cleansing. Anyone know of a way to get Excel to save a worksheet as a CSV (or any other text format) where the fields are enclosed by double-quotes? The best I can manage is to concatenate four double quotes onto the front and back of each field, which produces a CSV with three double quotes around each field, which I then have to open in Word/text editor and find/replace back to single quotes. I've hade a poke through the "help", tried all the likely looking Excel save formats, and I can't see any options that seem to apply. Any suggestions for fixing this in Excel? Or perhaps some kind soul willing to knock me up a quick app that takes a big (10-20mb) text file and converts instances of """ to "?