Can't import file with having a period in the name

[MTSPEER]

Hello,

I'm kinda confused why I can't import a file into my table when there is a period in the file name. I'm using the code:

DoCmd.TransferText _


TransferType:=acImportDelim, _
SpecificationName:="Test", _
TableName:="Test1", _
FileName:=Test1.010101.txt, _
HasFieldNames:=False

[JoeM]

Periods in file names (that do not precede the file extension) are problematic.
You can rename the file in your VBA code before importing it to get around that issue.
See: https://www.accessforums.net/import-...iod-31395.html

[John_G]

The file name should be in quotes too - "Test1.010101.txt"