Recent content by newaccessvba

Thanks, ypma. My problem is the periods in the filenames. There is no space in the filenames.

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...