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

Related LIT software: litLIB: Excel power functions pack ExcelLock: Locks and secures your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Demos

Buy now

Download now

SQL*XL video demos
 

SQL*XL: Add rows to table.

Add rows to table

In this demo rows will be added to a table. SQL*XL's multiple rows insert form is opened and still contains the data from the demo on how to insert data into a new table.

 

Selecting the data field allows the selection of cells on the spreadsheet. Instead of scrolling down I use the keyboard shortcut Shift-Ctrl-Down. This will select all the contiguous rows and in the data field the address of the cell range is displayed.

 

The insert into Oracle completed within a second. One error was encountered. A description was bigger than allowed. Errors are (optionally) sorted to the top for convenience. As you can see, errors are quickly fixed.

 

A query on the whole table verifies the add rows operation.