Am I doing something wrong or are file names that include a period illegal? I have two identical csv files (PhoneList.csv and Phone.List.csv) but the latter one can't be opened using ADO and Jet.

Code:
Sub ADO_Fail()
    Dim objConn As Object
    Dim objRs As Object
    Dim strPathtoTextFile As String
    
    Set objConn = CreateObject("ADODB.Connection")
    Set objRs = CreateObject("ADODB.Recordset")
    strPathtoTextFile = "C:\"
    
    objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=" & strPathtoTextFile & ";" & _
              "Extended Properties=""text;HDR=YES;FMT=Delimited"""
              
    'works ok
    objRs.Open "SELECT * FROM PhoneList.csv", objConn, 3, 3, 1
    objRs.Close
              
    'fails ==> The Microsoft Jet database Engine could not find the object Phone.List.csv...
    objRs.Open "SELECT * FROM Phone.List.csv", objConn, 3, 3, 1
    objRs.Close

    objConn.Close
    Set objRs = Nothing
    Set objConn = Nothing
End Sub