Import XML into Access w/ # in filename

We have an application that generates XML documents that need to be imported into Access. Most of these XML documents typically have a ‘#’ character in the filename (example: Jones#49.xml).

For some reason, Access will not import these, but the documentation does not indicate that a # character is a problem. We can get around this problem by renaming the file without the # character, but this is a burden for our users. They need to be able to import the xml files as they are.

1) Can anyone tell me why Access won’t import xml documents with a # sign? (There doesn’t seem to be any documentation that talks about this problem.)

2) Is there anyway to fix this problem without renaming the file?

All attempted responses will be appreciated. Thank you.