Insert rows into a new table
In this demo website data will be copied to a spreadsheet and inserted into a new table. SQL*XL's multiple rows insert form is used to create the table and to insert the data.
When the data is copied into the spreadsheet, column names are added for convenience. You can also type them into the insert dialog. The create table checkbox is ticked so SQL*XL will start the create table form. Inserting the data is quick and easy.
A query on the table verifies that the table is created and that the rows were added.