Withdata software has announced withdata mysqltoexcel 1.9, a data conversion tool that export MySQL data to excel. Withdata MysqlToExcel 1.9 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. Withdata MysqlToExcel – ... Read more
Author Archives: Shiji Pan
Withdata Software Released Withdata MsSqlToExcel 1.9
Withdata software has announced withdata mssqltoexcel 1.9, a data conversion tool that export ms SQL Server data to excel. Withdata MsSqlToExcel 1.9 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. Withdata MsSqlToExcel ... Read more
Withdata Software Released Withdata DB2ToExcel 2.0
Withdata software has announced withdata db2toexcel 2.0, a data conversion tool that export DB2 data to excel. Withdata DB2ToExcel 2.0 add “Task Schedule”, add support to XML type field, improve export performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released Withdata AccessToExcel 2.0
Withdata software has announced withdata accesstoexcel 2.0, a data conversion tool that export Access data to excel. Withdata AccessToExcel 2.0 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. Withdata AccessToExcel ... Read more
Withdata Software Released SqlToTxt Version 2.5
Withdata software has announced sqltotxt 2.5, a data conversion tool that export SQL Server data to flat file (csv, xml, html, sql) and excel. SqlToTxt 2.5 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. SqlToTxt ... Read more
Withdata Software Released MyToTxt Version 2.2
Withdata software has announced mytotxt 2.2, a data conversion tool that export MySQL data to flat file (csv, xml, html, sql) and excel. MyToTxt 2.2 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. MyToTxt – The ... Read more
Withdata Software Released DB2ToTxt Version 2.0
Withdata software has announced db2totxt 2.0, a data conversion tool that export DB2 data to flat file (csv, xml, html, sql) and excel. DB2ToTxt 2.0 add “Task Schedule”, add support to XML type field, improve export performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released AccessToFile Version 2.3
Withdata software has announced accesstofile 2.3, a data conversion tool that export Access data to flat file (csv, xml, html, sql) and excel. AccessToFile 2.3 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing ... Read more
Replace Update or Insert a row Into PostgreSQL Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in PostgreSQL? A way to do an “UPSERT” in postgresql is to do two sequential ... Read more
Replace Update or Insert a row Into Sqlite Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in Sqlite? Use “INSERT OR REPLACE INTO” . For example: INSERT OR REPLACE INTO Employee ... Read more