I wanted to link text files in Access using VBA and tried out the DoCmd.TransferText method. It worked well with regular file names. However, the text files that I need to link include extra periods in the file names (e.g. site_abc_glc.120305_120307_125732_1.csv). The periods cause an error when...