Replacing Special Characters

[Pete666]

I am exporting an Access table as an xml file and need to be able to identify and replace '&', '(' and ')' as they are not accepted in xml.

Does anyone know how a query can be built which will find these characters in fields and update to ' and' or just remove?


Thanks

 

[Dennisk]

access has a replace function