Type the table name you wish to insert the data into.
Either type the column names (comma separated) or use the button to use the mouse to select the range containing
the column names. SQL*XL will build the comma separated column names list for you. For example:
employee_nr , employee_name , salary
The Data Range:
Use your mouse to click on the spreadsheet to select the range of data cells. Just select it as a single block
and you will see that SQL*XL writes the cell addresses in the input field. For example:
Now just press the OK button and all the data will be sent to the database. It's as easy as this! Progress information
will be shown in Excel's statusbar as % completed. Every now and then SQL*XL will refresh the screen so you can
see the progress for yourself. At the end of each row in your spreadsheet SQL*XL will put a status indicator: successful
or a short error message.
Data errors may occur. Most databases have rules to accept data. There are constraints that specify which data
is acceptable. If SQL*XL finds a problem it will put an error message next to the row. After the insert process
you can easially review the problem rows. You have to fix the data errors and resubmit the failed rows only. SQL*XL
makes it easy for you to sort all failed records to the top of the spreadsheet.
I advice to leave the commit each row setting on. Some
databases implement read consistency and therefore keep changes of one user
separate to other users. This only works well if you don't do too many
changes. If you bulk load a lot of data you may find your database complaining
with all the data inserted so far being rolled back.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.