IssueWhen you try to connect to a .csv or .txt file that contains multiple periods in the file name using a Legacy connection, the following error might occur:
Unable to open the text file. Please check that you have specified the correct field delimiter and that you have access privileges for the file.
Microsoft JET database error 0x80004005: The Microsoft Jet database engine could not find the object 'file.1.csv'. Make sure the object exists and that you spell its name and the path name correctly.
The table "file#1#csv" does not exist.