CsvToAccess 5.0 Released Download

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

2022/03/11
V4.9 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
V4.8 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/11/29
V4.7 Released
Add suport Linux.
Add suport macOS.
Improve importing performance.

2021/11/12
V4.6 Released
Fix "create table".
Improve "read big text file performance".

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

2021/03/19
V4.4 Released
Improve importing performance.

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

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

2020/11/01
V4.1 Released
Fix adjust table list width.
Fix move files after importting.

2020/04/08
V4.0 Released
Add option "source filename as column"
Add parse "US$" format string to number.
Fix lost break lines when write multiple lines data to string field.
Improve map columns.

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

2018/08/01
V3.8 Released
Add import from INI file.
Add suggest data type on creating table.
Fix write empty string to CLOB/TEXT field.
Improve convert with large column count.
Improve parse TXT/TSV/CSV file quote char.

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

2017/12/01
V3.6 Released
Add view TEXT(CLOB) by mouse click.
Fix import string contains single quote.
Fix load data to ftVarBytes field.
Improve support to read big TXT/CSV/TSV file.

2017/04/18
V3.5 Released
Add "move successful files to another folder" function.
Add check file path exists before create Access file.
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.
Fix bug on data file contains empty line.
Fix bug on source data file name has no ext.
Improve support for converting files from folder.

2016/11/12
V3.4 Released
Add "Reload data" when changed encoding.
Add "Show table DDL".
Fix import date with format "YYYYMM".
Fix import date/integer/float/bool data bug when data is "N/A".
Improve wizard form UI.

2016/08/19
V3.3 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.2 Released
Add field name length limit on creating table.
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.

2016/03/12
V3.1 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/17
V3.0 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 support for importing unicode data.
Improve support for more datetime format.
Improve support for more large integer field.
Improve support for value "(null)".

2015/03/27
V2.9 Released
Add "Show scheduled tasks".
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" .
Add support to import number format contains ",".
Improve convert performance significantly.

2015/01/26
V2.8 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 about write bad file in "Load From Folder"
Fix bug on "create bad file error".
Fix bug on "load folder save to sql truncate the sql file".
Imporve "Create Table", auto fix table/field name before create.
Imporve datetime convert support.
Imporve notify when can not create session file.

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

2014/10/14
V2.6 Released
Add "turning off log" in command line.
Improve exception report.
Fix bug "import form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.
Fix bug "failed load part columns data in command line".
Fix bug "logon to Access form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.

2014/4/18
V2.5 Released.
Add "Bad File" to log failed import records.
Add "Create new Access file"  to logon form.
Add "Exception Report From".
Improve import performance.

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

2013/5/17
V2.3 Released.
Add "Execute Sql from Command line".
Add "Match filter (wildcard)" to "Import from folder".
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 "count unicode file lines inacculately".
Some other bug fixes and enhancements.

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

2012/3/7
V2.1 Released.
Add "right click tab to rename/close form".
Improve "progress update".
Fix a bug of "trim CRLF".
Fix a bug about Numeric data.
Some other bug fixes and enhancements.

2011/5/17
V2.0 Released.
Add wizard to "import from folder".
Add easy way to custom "Quote" and "Delimiter".
Imporve user interface.
Some bug fixes and enhancements.

2011/3/11
V1.8 Released.
Add "WordWrap" option to Query form.
Fix importing bug when file contains unicode line-break.
Fix bug about "copy/paste with TAB in Query form".

2010/8/9
V1.7 Released.
Improve "save/load session".
Improve query form.
Improve user interface.
Fix "parse utf8 data" bug.

2010/5/29
V1.6 Released.
Improve user interface. 

2010/3/24
V1.5 Released.
Add "list recent access files".
Add "list recent csv files".
Add "list recent folders".
Improve interface for loading multiple files. 

2009/9/14
V1.4 Released.
Add support to Unicode.
Add "Create Table".

2009/6/11
V1.3 Released.
Add "Open/Save Workspace".
Some bug fixes and enhancements.

2009/5/13
V1.2 Released.
Add "create Access 2007 file(*.accdb)" function.
Add "Execute via command line" , enable automate exporting task.
Add support table name contains blank characters.
Add support field name contains blank characters.

2009/3/5
V1.1 Released.
Support Access 2007.
Add "Update" load type.
Some bug fixes and enhancements.

2008/12/22
V1.0 Released.
First Release.

	

---