Late on this one, only just joined!
If you create a temprary table of the records to be exported, a function such as that below can be used to modify the temporary records before export. Note that you need only open the recordset as "rsTemp" and loop through it to make all the changes, calling...