Search Results for "microsoft"

...It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. It is open source GPL v3 and crossplatform, it can run on most operating systems that can run Python (Python is required). More details, example files, and online manual at http://csv2odf.sf.net.

This CSV and TXT file splitter firstly allows you to work with large data files. We have tested this on the largest CSV file we could find. It had over 25.6 Million rows. Microsoft Excel can only load 1 Million rows. So the challenege was on! Splitting a file in this case by 990,000 rows made sure that it was more than capable to load into excel. Splitting 25.6Million rows took aroud 50 minutes. Has been tested reading 25Million rows which took around 15 seconds to read. Its made using the .NET framework version 4.6

"Database to CSV" allows to back-up data from database(Oracle, MySQL, SQL Server) in the form of CSV files. Each table data is stored in a separate CSV file. It also allows to load data from CSV files into the database. Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line. (It will take foreign keys and unique keys into consideration and then try to insert...