Period in Text Filename

[newaccessvba]

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 executing the DoCmd.TransferText method. I did some research and noticed that the files need to be renamed to use the method. Is it possible to make the method work without rename the files? Please help.

 

[ypma]

Not used this method but, when referencing forms with spaces i enclose the form name wtih inverted commas "File Name" or pehaps you could try enclosing the File Name with Brackets.
Will leave it to someone more apt at this procedure .

 

[newaccessvba]

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