Current version is developed for Excel 2003 and Excel 2007. The xls4oracle is verified on Windows XP, Windows Vista and Windows 7. To use the tool you need:
-
Oracle Database 10g Client Release 2 (10.2.0.1.0) - with a valid tnsnames
and download the tool. If you allready installed sql*plus, the OO4O should be include in that installation.
This is the full functional version, but without a proper license key it has limited dataload functionality. Get a trial key, that will enable you the full dataload functionality for a limited time.
You need to register (free of charge) and login before download. Get a free trial key
Latest release: 3.6.10.223
Release 3610223
25-may-2010 / Thomas Lundqvist
- fixed license key bug – new license key needed
- more rows & columns in excel 2007
- dataload form added
- encrypted passwords
- easy entering of license key on the about form
- when non apps connection (preprod/prod) and script load – need for ability to generate apps_initialize…
- $filename – must handle ext. diff from len=3
- must handle trace > 4 (dies when trace=99)
- optimized the sql part
- trace enabled on sql
- progress info in the sql functions
- fixed issue with script load
- new password encryption for R12
- SQL: enabled logon sql to set client info for non-apps connections
=============================================================
- fixed license key bug – new license key needed
The license key bug was making it impossible for licenced users to register. New encryption developed, that requires a new license key. All regisrered users will receive new license key, when this release is fully tested. Pls. continue to use the trial license key found on xxls4oracle.com.
- more rows & columns in excel 2007
16000 columns and 1 million rows in excel 2007
- dataload form added
userfriendly database connection, application logon and responsibility selection.
New dataload type: online or script load. trace and spoolfilenames. No need to enter values on the system tab.
Radio buttons to control the commit levels.
Remember password: if database password is to be remembered, the dataload sheet will be protected, preventing any change in the plqsl program.
- encrypted passwords
The database password and appl passwords is stored encrypted.
- easy entering of license key on the about form
The license key can now be entered on the about form.
- when non apps connection (preprod/prod) and script load – need for ability to generate apps_initialize…
is now checking for apps connection. when connection username is not APPS - only script load is allowed. this enables resp. selection when loading to prod env.
- $filename – must handle ext. diff from len=3
$filename is now without extension and handles the new 2007 extensions: xlsb, xlsm…
- must handle trace > 4 (dies when trace=99)
fixed…
- optimized the sql part
The count number of records function is costing – so its gone. For queries with many records, the count is using aprox. the same time for getting the count as doing the fetch. The drawback is that the progress bar also must go. The only feedback is the count of fetched records, and it is now set to update for every 100 records.
- trace enabled on sql
Will use system sheets “trace” value. This will enable improved support for the sql function.
- fixed issue with script load
Was unable to do script load. Issue fixed.
- new password encryption for R12
All the UTF8 character set (with a few exceptions) is enabled for passwords in R12. R11 did only allow like 36 characters – this required a new encrypt decrypt algorithm.
- SQL: enabled logon sql to set client info for non-apps connections
The SQL function did ignore any logon sql’s for non-apps connections. Logon sql is now enabled for all connections, enabling to set client info for readonly connections.
If you need help with the setup:
Pls. contact: support@xls4oracle.com
Previous released: