Last Modified Date: 21 Apr 2019
Environment
- Tableau Desktop 8.2 and later, but earlier than 2019.1 (See Additional Information)
- Microsoft Excel
- Text Files
Resolution
- From the Home page select Connect to Data.
- Select Microsoft Excel.
- In the Open dialog box, select the desired Excel file.
- Click the down arrow next to the Open button in the dialog box and select Open with Legacy Connection.
- On the left hand side of the Data pane, click New Custom SQL.
Cause
The ability to create a data connection with custom SQL to a flat data source such as Excel, Access, or text files is currently not built into the product.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.
Discuss this article... Feedback Forum
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