Want to batch import data from files to 1 database table? Using FileToDB, a native GUI tool, you can batch import data from files to 1 database table easily and fast, no need to program, just a few mouse clicks! Support multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, ... Read more
Author Archives: Shiji Pan
Import data from file to database table without programming
Want to import data from file to database table? Using FileToDB, a native GUI tool, you can import data from file to database table easily and fast, no need to program, just a few mouse clicks! Support multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc. Support multiple ... Read more
Import/Export database data from/to files without programming
Want to load/unload database data from/to files? Using DBLoader, you can load/unload database data from/to files easily and fast, just a few mouse clicks! You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc. You can export data to multiple types of ... Read more
Import/Export MongoDB data from/to files without programming
Want to load/unload MongoDB data from/to files? Using MongoLoader, you can load/unload MongoDB data from/to files easily and fast, just a few mouse clicks! You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc. You can export data to multiple types of ... Read more
How to batch convert text to wav
Want to batch convert from text files to speech in audio formats .wav files? Using TTSBatchConverter, you can batch convert from text files to speech in audio formats .wav files easily and fast, just a few mouse clicks! Here you can download and install TTSBatchConverter. Batch convert from text ... Read more
How to batch convert text to mp3
Want to batch convert from text files to speech in audio formats .mp3 files? Using TTSBatchConverter, you can batch convert from text files to speech in audio formats .mp3 files easily and fast, just a few mouse clicks! Here you can download and install TTSBatchConverter. Batch convert from text ... Read more
Use Oracle Instant Client
Download Oracle Instant Client: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html Unzip the file after download, then add the instant client folder to the system path. To use the instant client to connect to Oracle database, you need to create a tnsnames.ora ... Read more
Upsert a row Into Mysql 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”. INSERT INTO employees(id, name, hire_date ) VALUES (1, 'John', '2016-11-29' ) ON DUPLICATE KEY UPDATE ... Read more
Batch import RTF files into Oracle BLOB without programming
Want to batch import RTF (Rich Text Format) documents into Oracle CLOB or BLOB column? Using OraLobEditor, you can import bulk rtf files into Oracle CLOB or BLOB easily and fast, just a few mouse clicks. Here you can download and install OraLobEditor. Batch import RTF documents to Oracle ... Read more
Batch import RTF files into SQLite BLOB without programming
Want to batch import RTF (Rich Text Format) documents into SQLite CLOB (TEXT, NTEXT) or BLOB column? Using DBBlobEditor, you can import bulk rtf files into SQLite CLOB (TEXT, NTEXT) or BLOB easily and fast, just a few mouse clicks. Download DBBlobEditor Batch import RTF documents to SQLite CLOB ... Read more