Assuming this is a one off, is there any problem, loading the data with a different name and then just manually going and adding in the "/"s? Perhaps I've missed something?
Special characters are always a challenge and even though Access may support naming conventions like this they are not especially portable and can often result in very ugly warnings returned by the target system or just confusion! In this case it seems FME is tripping up in attempting to clean up the potential problem.
You might try the ODBC writer instead of the Access writer to see if it performs differently. But I'd doubt it as the default operation of the adding an attribute name anywhere in FME manually with a / in the name is to swap it to an underscore.
HI
I'm having the same issue with access database and fields that contains caracters such as : slash /, dash -, apostrophe '
Fme is unable to write fields with those caracters, which means trouble for me.
For now, i'm renaming the fields and I need to remember to rename manually the fields using Access afterwards, but unfortunatly sometimes I miss one database...oups!
Is there any chance that some day, FME will write these caracters?
Thank you for your answers!