Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Features

Buy now

Download now

SQL*XL online help


SQL*XL: Rerun a query

Rerun a query


After a query was executed it can sometimes be handy to be able to rerun the same query and effectively refresh the data. In SQL*XL there exists a shortcut to achieve this.

Simply select the top left cell of the previously created resultset table and execute the menu command SQL*XL|Query. It will now load the SQL back into the query editor of SQL*XL. You can now rerun this SQL statement.

A few usage notes:

- This technique only works when the SQL was saved in a note with the query results when you ran the query initially.
- Only select the top left corner of the results table, so select only 1 cell!
If more than 1 cell is selected, SQL*XL will take the contents of all cells and use that as the SQL statement.

See also:

SQL*XL ribbon in Excel