appSettings, the & char and 'error occured while parsing EntityNam

[Guest]

I have a file name in my app.config file which contains the & character.

<appSettings>
<!-- User application and configured property settings go here.-->
<!-- Connection string values -->
<add key="ExcelFileName" value="T:\HR & Development\Personnel\Weekly
Report\Weekly Report.XLS" />

When I try to read this in my app, I get an 'error occured while parsing
EntityName'. Now I've found out that this is a known problem, but how do I
get around it without changing the value= field.

TIA

 

[Guest]

Found the solution, at last! You need to replace the & character with &amp;
D'oh!