Paste mode optiongroup (Resultset options dialog)

SQL*XL home

When Excel is selected as target for the fetched results, SQL*XL will put the data in an Excel worksheet. SQL*XL can overwrite the existing data or you can let SQL*XL insert new rows for the database data. Choose "overwrite cells" for the faster overwrite mode or choose "insert cells" mode to insert new rows for the data preserving other data on the sheet.

See also:

• Resultset options dialog