XlsToOra 5.4 Released Download

2022/05/29
V5.4 Released
Merged to FileToDB.

2022/03/11
V5.3 Released
Fix detect BOM.
Fix parse date format in file when creating table.
Fix write bad file.
Improve display progress for estimated rows.
Improve import number to db.

2022/02/02
V5.2 Released
Adjust UI.
Fix "Cancel" on wizard dialog.
Fix "not display columns when have no relative table".
Fix load session with part columns.
Improve create batch file for running scheduled task on Windows.

2021/10/05
V5.1 Released
Add "SSH tunnel connect" to Oracle.
Add connect Oracle by service name through "TCP/IP connect".
Add more "Connect as" to Oracle logon form.
Improve import Excel data.
Support Widnows (32bit and 64bit), Linux (64bit), MacOS (64bit).

2021/07/28
V5.0 Released
Fix bugs caused by incompatible library version.
Improve create table.

2021/03/19
V4.9 Released
Add support to Oracle 21c.
Improve importing performance.

2021/02/17
V4.8 Released
Add "run a task every n hours".
Add "run a task every n minutes".

2021/01/05
V4.7 Released
Add "Save To SQL File".
Improve data convert performance.

2020/11/01
V4.6 Released
Add support to Oracle 20c.
Fix adjust table list width.
Fix move files after importting.

2020/04/08
V4.5 Released
Add option "source filename as column"
Add parse "US$" format string to number.
Add support to Oracle 19c.
Fix calculate record number on multiple sheets.
Improve map columns.

2019/07/19
V4.4 Released
Fix a file choose bug.
Fix a folder choose bug.
Fix an SSL connect issue.
Improve importing performance.

2019/04/10
V4.3 Released
Add support to Oracle 18c.
Fix bug on importing data from non-first sheet.
Fix bug on reading some XLSX files.

2018/08/01
V4.2 Released
Add suggest data type on creating table.
Fix write empty string to CLOB/TEXT field.
Improve convert with large column count.

2018/03/19
V4.1 Released
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.

2017/12/01
V4.0 Released
Add view TEXT(CLOB) by mouse click.
Fix import string contains single quote.
Fix load data to ftVarBytes field.

2017/04/18
V3.9 Released
Add "move successful files to another folder" function.
Add convert data from web.
Add handle for skip rows big than total rows.
Add support date format like: "20150101 13:43:29".
Add support date format like: "2016-04-12T18:37:09-07:00".
Add support date format like: "2016-07-21T17:18:52Z".
Add support date format like: "Fri, 21 Oct 2016 13:08:32 +0800".
Add support date formats like: "2015:06:21", "2015:06:21 08:02:48", "2016:03:20 20:08:08-06:00".
Add view target table after importing.

2016/11/11
V3.8 Released
Add "Show table DDL".
Fix import date with format "YYYYMM".
Fix import date/integer/float/bool data bug when data is "N/A".
Improve fetch Oracle SERVICE_NAME and SID.
Improve wizard form UI.

2016/08/19
V3.7 Released
Add "Create Table" on right click menu.
Add "Database Object TreeView".
Add "Drop Table" on right click menu.
Add "View Table Data" on right click menu.
Add "View Table Struct" on right click menu.

2016/07/21
V3.6 Released
Add support importing data to field that field name contains "~".
Add support to more number formats.
Adjust login form.
Improve command line, made it more simple.
Improve parsing date format.
Improve parsing number format.
Improve support to importing unicode data to Oracle CLOB/NCLOB field.

2016/03/12
V3.5 Released
Add set default field type on creating table.
Add support importing data to field that field name contains "&".
Improve support to importing empty string data to not null field.

2015/07/01
V3.4 Released
Add support to field contains "<" or ">".
Add support to field contains line break.
Fix bug on edit data in resultset grid.
Improve execute in command line, will close if can not login database.
Improve reading Excel file.
Improve support for more datetime format.
Improve support for more large integer field.
Improve support for value "(null)".

2015/03/27
V3.3 Released
Add "Show scheduled tasks".
Add notify when load multiple data to one field at same time.
Add support create table on non-default schema.
Add support to Netherland number(currency) format like "96.325,75-".
Add support to date format like "22.12.2005." and "25.7.2008. 21:15:05" .
Add support to import number format contains ",".
Fix bug on changing target schema.
Fix import error when Oracle table name is lower case.
Fix import error when field name is Oracle reserved keyword.
Improve convert performance significantly.

2015/01/26
V3.2 Released
Add command-line and schedule task support to "save to sql".
Add notify when can not create log file.
Disable exception window when run in command-line.
Fix bug about can not close form when exception raise.
Fix bug on "create bad file error".
Fix bug on import/export data when schema/table/field name contains double quote.
Imporve "Create Table", auto fix table/field name before create.
Imporve datetime convert support.
Imporve notify when can not create session file.
Improve support for Oracle 11g 11.2.0.4.

2014/11/07
V3.1 Released
Change reg code to license file.
Improve exception report.
Improve save session file, auto add folder and ext.
Fix bug "import form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.
Improve "create target table", target table name auto change to created table.
Improve support to Oracle 12C.

2014/07/14
V3.0 Released
Add "Bad File" to log failed import records.
Add "turning off log" in command line.
Fix bug "falied load part columns data in command line"

2013/7/25
V2.9 Released.
Add "Task Schedule".
Improve import performance.
Fix "division by zero" bug in importing process.

2013/5/24
V2.8 Released.
Add "Execute Sql from Command line".
Add "Check Update" to menu.
Improve importing performance.
Improve importing exception notify, more exactly line number.
Fix "Execute update sql error".
Fix "Save To Sql" with "Update" type. 
Fix bug of exporting multiple sheets at one time.
Some other bug fixes and enhancements.

2012/9/11
V2.7 Released.
Add "Make Batch File".
Improve "Date Format Config".
Some other bug fixes and enhancements.

2012/3/6
V2.6 Released.
Add "right click tab to rename/close form".
Improve support to Unicode.
Improve "progress update".
Some bug fixes and enhancements.

2011/5/18
V2.5 Released.
Add "Update" type to load data.
Add "Erorrs to allow" option.
Imporve user interface.
Some bug fixes and enhancements.

2011/3/10
V2.4 Released.
Add "WordWrap" option to Query from.
Fix importing bug when sheetname contains "-".
Fix bug about "copy/paste with TAB in Query form".

2010/8/16
V2.3 Released.
Improve "save/load session".
Improve query form.
Improve user interface.

2010/6/10
V2.2 Released.
Improve user interface.
Fix bug of load skipped columns session.

2010/4/14
V2.1 Released.
Add "list recent Excel files".
Add "Open/Save Workspace".

2010/2/24
V2.0 Released.
Fix clob unicode problem when importing Excel data.
Fix edit data in "Show data".

2009/8/29
V1.9 Released.
Add an option to use header row as fieldnames to create a table with.
Some bug fixes and enhancements.

2009/6/2
V1.8 Released.
Add "import all sheets at a time".
Add "Execute via command line" , enable automate importing task.
Improve importing Excel 2007 file.

2009/3/20
V1.7 Released.
support Excel 2007.
improve Excel reading performance.
support save sql with unicode encode.
support schema name, table name and field name contains quote char.

2009/2/5
V1.6 Released.
add "Import Wizard".
fix some bugs.

2008/11/19
V1.5 Released.
add "update existing rows" function.
fix some bugs.

2008/7/8
V1.4 Released.
add "automatically reconnect" function.
add "set NLS_DATE_LANGUAGE" function.
"Select Columns" dialog show excel data(header). 
fix "replace" load bug.

2008/4/23
V1.3 Released.
improve "selece excel columns" function.
improve unicode support.

2008/2/29
V1.2 Released.
add OCI alias list show at Logon dialog.
enhance null data import. 
fix preview grid change bug caused by header switch.
some other bug fix.

2007/8/1
V1.1 Released.
logon dialog support oci.
add schema switch support. 
add unicode support.
add clob,blob support.
add "data cell paste" function.	
add "save/load import session" function.
import ui enhancement.

2007/7/3
V1.0 Released.
First Release.


	

---