Data Result Set | Export option to export to an Excel file only allows up to 65000 records to be (4312839)

Data Result Set | Export option to export to an Excel file only allows up to 65000 records to be

Data Result Set | Export option to export to an Excel file only allows up to 65000 records to be exported.Excel 2007 has expanded this limit to overone million rows.

WORKAROUND:

1. Save the export in SQL Navigator as a Delimited text format (.csv).
2. Open the .csv file in Excel and use the Excel Text Import feature.
3. Run the wizard to import all data to an Excel format file.

Alternatively, a .csv file may be just saved as an .xlsx file, but it's preferred to use the wizard for further options.

STATUS:

This issue is fixed in SQL Navigator for Oracle 7.0. This version can be downloaded at https://support.quest.com/softwaredownloads.aspx?pr=268435514&pv=4294946839.

ST5269

In SQL Nav 7.0, if the number of records exceeds 65000, a new sheet is opened in the same Excel workbook and the export continues onto the next sheet. If that sheet hits 65000 records, then a third sheet is opened and so on. Enhancement ID 'SQLNAV-1229' was logged to have SQL Nav export all the records to one Excel sheet, for the newer versions that allow over 65000 rows one on sheet. That enhancement is scheduled to be out in v7.1, but that is not a guarentee. It is possible that it can be pushed back to a later release.