title: Importing a file in Access which contains "." in it's name using VBA
body: <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>