AccessToSqlite News

2022/05/26
V4.3 Released
Merged to DBCopier.

2022/03/11
V4.2 Released
Fix parse date format in file when creating table.
Fix write bad file.
Improve display progress for estimated rows.

2022/02/02
V4.1 Released
Improve create batch file for running scheduled task on Windows.

2021/12/30
V4.0 Released
Fix "create table".
Fix create new SQLite file with password.
Improve converting performance.

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

2021/03/19
V2.9 Released
Improve importing performance.

2021/02/24
V2.8 Released
Add "run a task every n hours".
Add "run a task every n minutes".

2021/01/05
V2.7 Released
Add "Save To SQL File".
Fix view target table data on transfer tables.
Improve data convert performance.

2020/11/01
V2.6 Released
Fix adjust table list width.
Fix bug in batch transfering data from tables when target table name not same as source table name.

2020/04/15
V2.5 Released
Improve import part rows and skip rows.
Improve map columns.

2019/07/19
V2.4 Released
Improve importing performance.
Some other bug fixes and enhancements.

2018/08/02
V2.3 Released
Add convert "Struct Only".
Fix write empty string to CLOB/TEXT field.
Improve convert with large column count.

2018/03/19
V2.2 Released
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.
Improve performance by build index after convert.

2017/12/01
V2.1 Released
Fix import string contains single quote.
Fix load data to ftVarBytes field.

2017/06/14
V2.0 Released
Add "transfer N tables data to 1 table".
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 TEXT(CLOB) by mouse click.
Add view target table after importing.

2016/11/12
V1.9 Released
Add "Show table DDL".
Fix convert data from view.
Fix export query results that can not count records.
Improve convert combine primary key.
Improve wizard form UI.

2016/08/22
V1.8 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/20
V1.7 Released
Add "Set default value for field" on creating table.
Add support converting index, primary key, and default value on creating tables.
Add support importing data to field that field name contains "~".
Adjust login form.
Improve command line, made it more simple.
Improve converting data type on creating table.

2016/03/14
V1.6 Released
Add support importing data to field that field name contains "&".
Fix bug that caused by break line in sql query.
Improve auto create table contains GUID field.
Improve support to importing empty string data to not null field.

2015/07/20
V1.5 Released
Add auto parsing datetime format when create new table in batch convert.
Add support to field contains "<" or ">".
Add support to field contains line break.
Fix bug at click config button on batch converting tables.
Fix bug at converting data to created table that source table name contains special characters.
Fix bug at create table when batch converting tables to no-default schema.
Fix bug on edit data in resultset grid.
Improve execute in command line, will close if can not login database.
Improve support for more datetime format.
Improve support for more large integer field.

2015/03/27
V1.4 Released
Add "Show scheduled tasks".
Add SQLite boolean type to create table.
Add notify when load multiple data to one field at same time.
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" .
Improve convert performance significantly.

2015/01/26
V1.3 Released
Add "Create bad file for failed convert records".
Add "Create new SQLite DB file".
Add "Login to encrypted SQLite file".
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 "change schema in importing tables to tables".
Fix bug on "export single table" with clob field.
Imporve "Create Table" on "Import All Tables", auto fix table name on creating.
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 create table from query.

2014/11/07
V1.2 Released
Improve "create target table", target table name auto change to created table.
Change reg code to license file.
Fix bug "create tables error" on "Import data from tables to tables".
Improve save session file, auto add folder and ext.
Improve exception report.
Improve Access logon form, auto remove the non-exists Access file name from history list.
Fix bug "logon to Access form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.
Fix bug "logon to SQLite form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.
Improve Sqlite logon form, auto remove the non-exists Sqlite file name from history list.

2014/08/13
V1.1 Released
Add "turning off log" in command line.
Fix bug "failed load part columns data in command line".

2013/11/15
V1.0 Released.
First Release.