Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
- Text files
Resolution
Option 1: Connect to Excel instead
- Move the data into a Microsoft Excel file.
- In Tableau Desktop, connect to the Excel file.
Option 2: Use a schema.ini file with legacy connection
- Create and use a schema.ini file. The schema.ini file should specify that fields with Long Integer data types should be treated as Double data type. For more information, see Schema.ini File (Text File Driver) in the Microsoft Dev Center. Creating the schema.ini file will allow the Microsoft JET Database Engine to correctly recognize data types.
- In Tableau Desktop, browse to your data file, click the drop-down arrow on Open, and then select Open with Legacy Connection.
Cause
When columns are more than 2^31 = 2147483648, the driver is unable to read the numbers, because it uses a 4-byte integer, and larger numbers do not fit.When using Excel, the driver reads cells as double data type, so the error doesn't occur.
Additional Information
Note: Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials