Return
-
Title
Error exporting a table with over 256 columns via Data Grid | Save into an Excel 2007 .XLSX file: -
Description
Although the current Toad supports Excel 2007 files which allows more than 256 columns, when using the Data Grid | Save option to export a table with over 256 columns and entering .XLSX file as the Output file, Toad still errors out to:
"Excel allows a maximum of 256 columns and your dataset has xxx. Aborting"
Toad is not recognizing the .XLSX file type which is a 2007 Excel file, and hence, should allow the export. Also, in the Browse option of Output file, only .XLS file type is available in the list of Excel files.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.