Copying Results to Excel

You can copy the Compare Results to Excel with Edit > Export Results to Excel.

A dialog box will be shown where you can specify the name of the Excel file and the name of the worksheet.

• you can specify <schema> or <tname> in the file or sheet names. AQT will substitute the schema and table name of the Compare table in the names.
• if the sheet already exists, it will be overridden. There is no option to append to an existing sheet.
• if you check the box Create new Sheet if Exists then, if the specified sheet already exists, a new sheet will be created. This name of the new sheet will be the specified sheet name with a sequence number added onto the end.

Exporting to Excel is slow; this feature is not recommended if you have a lot of data. If your tables are large, you can reduce the amount of data in the result grid by specifying the option Only show rows that are different.

The data exported to Excel will include the highlight color indicating that values are different. However the first column in the Excel file will not have the tick or cross icons showing the status the cell. Exporting images to Excel is very slow; instead the first column will have a color indicating the status of the row:

• green - rows are the same
• red - rows have some cells which are different
• orange - row present in one table but not the other