Importing a file in Access which contains "." in it's name using VBA
<p>I am trying to import a csv file into my access database. It reads like this:
"Vol.2016.Aug.23.csv"</p>

<p>When I try to import this using docmd, it gives me an error that it cannot import the file. I figured out the problem that it cannot identify the file as a csv because of the multiple "." </p>

<p>However, I would be getting files named in such a way which I need to import. Is there any way to go about this? </p>

<p>Please help!</p>

<p>Here's my code:</p>

<pre><code>fileName = "Vol." &amp; Year(Date) &amp; "." &amp; MonthName(Month(Date), True) &amp; "." &amp; Day(Date) &amp;  ".csv"

filePath = "C:\Users\House\Desktop\"

DoCmd.TransferText Transfertype:=acImportDelim, TableName:="Table1", fileName:=filePath + fileName, HasFieldNames:=True
</code></pre>