XML and Access

[Dragenesis]

Different users generate different xml files every day and, every day, I have to have to summarize what is in the xml files. I wrote a small script using loadxml command to load the xml files and extract the information I want from them. However, in order to load the files, I must pass on a file path and the file path is case sensative. This is a problem since the file names don't always stay the same. For example, a file that is usually named "Tiana.xml" may be named "tiana.xml" or "tiana-friday.xml" or "tiaNa.xml", depending on what the user types in. How do I make it so that the xml file will load regardless of case and use some kind of wildcard to pass to the loadxml procedure?

 

[Banana]

If the folder the files goes into are same, one way would be to search for all .xml files in the folder and get the exact name for each file then running loadxml command.

 

[gemma-the-husky]

surely any standard script etc, WOULD NOT be case sensitive with regard to file names - what code do you have exactly? Can you post it?

 

[Dragenesis]

My current code is basically this:

fpath = <absolute path to file>
if not xmldoc.load(fpath) then
<print error message>
end if

 

[ByteMyzer]

Why is the file path case-sensitive? Are you retrieving the file from a non-Windows source (Unix, for example)? Does your code module contain the statement Option Compare Binary? Could you furnish us with more details?

 

[Dragenesis]

Yes, the files are stored on a Unix server and Samba is used to connect the windows machines with the Unix servers. No I am not using option compare binary.