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
Withdata Software Released OraLoader Version 4.4
Withdata software has announced oraloader 4.4, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. OraLoader 4.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in ... Read more
Withdata Software Released XlsToSql Version 2.4
Withdata software has announced xlstosql 2.4, a data conversion tool that import Excel data to ms SQL Server database. XlsToSql 2.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToSql – A Better way to import ... Read more