Anyone know what exactly is too long in a field?
Does it mean I have to make sure there's no text in cells that long - or is a 'field' not the same as the underlying Excel cells?
I'll check the tables I've joined...
It now wont even retrieve a filter list on these global context filters, still saying '
Microsoft JET database error 0x80004005: The size of a field is too long.
Unable to create local query context'
'Microsoft JET database error 0x80040E21: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
The last tuple inserted was...........Unable to create local query context '
It's one error after another and with 20 minute query times between each, this is incredibly painful.
My apologies that you are having difficulties connecting to your data. As you suggested, the original error results because of the Jet data engine character limit of 255. This is not a restraint of Tableau, but of the Jet engine itself, which is why it won't be brought into Tableau. One possible way around this is to duplicate the data in a non-Jet data source, such as Microsoft SQL Server.
Below are the Microsoft Jet limitations:
- File size: 4GB
- Columns: 255
- Characters in text field: 255
For more information, visit the Microsoft Support site to read about new features in Microsoft Jet 4.0.
It sounds like the file itself may have been corrupted based on the last error received.
If you'd like additional help, I'd recommend sending a request to our support team with the problem file attached (firstname.lastname@example.org).
I'm not sure what caused the errors but I built back my dashboard from an earlier working version and that accepted the data set.