KNOWLEDGE BASE

Error "The table "file#1#csv" does not exist" Connecting to a .csv or .txt File


Published: 17 Jun 2013
Last Modified Date: 06 Feb 2014

Issue

When you try to connect to a .csv or .txt file that contains multiple periods in the file name, 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.

Environment

  • Tableau Desktop
  • .csv or .txt file

Resolution

Remove internal periods from the file name. 

For example:

file.1.csv should be renamed to file1.csv

file.1.txt should be renamed to file1.txt

Cause

File names cannot have more than one period. The naming limitation is set by the Microsoft JET technology used to connect to file-based data sources like .txt or .csv files.
Did this article resolve the issue?