I am trying to load a large Excel spreadsheet (84 columns x 530,000 rows) into an Tableau file. When I try to inport all the data into a tde extract, I am getting an "Out of Memory" message. I have tried several times and nothing seems to work. I have rebooted and tried to bring it into a fresh twb file.
The odd thing is that I have been doing fine with a slightly smaller file (84 columns x 400,000 rows).
Advice gladly appreciated. I have to get this file into Tableau.
What if you Open your Excel file in Excel, and save as a text/csv file and then connect Tableau to the text file for creating the extract? (you may need to make a schema.ini file to ensure the datatype are read correctly)