" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Use SQLCMD to Export SQL Query Result to a CSV File

Posted on November 24th, 2015 by Ratan Sharma

I recently had a requirement to purge older data from one of the database. Well yes, a single Delete query can do that easily. But we needed first to export those old data to CSV file, and then purge them from different tables, so incase needed we can import them back. There are many ways […]

Splitting A Large CSV Files Into Smaller Files In Ubuntu

Posted on November 24th, 2015 by Konakandla Pavan Kumar

To split large CSV (Comma-Separated Values) file into smaller files in Linux/Ubuntu use the split command and required arguments. split -d -l 10000 source.csv tempfile.part. Here “10000” indicates that each new file contains 10000 records,you change it to any number you want to, the smaller files would have that number of records. The new files […]

Reading CSV file and extracting records to DataTable in VB.Net

Posted on November 23rd, 2015 by Shibani Shubhadarshini

The following code lines can be used to read a file with .CSV extension and extract all records in the CSV file to a Datatable. We need to pass the complete Folder path and File name of the CVS file as the parameters to the function which will return a datatable with records from CVS […]

Creating an Excel sheet from a CSV file in VB.Net

Posted on November 23rd, 2015 by Shibani Shubhadarshini

The following code lines are useful to create an Excel sheet from a CSV file in VB.Net. We need to pass the complete folder path and csv file name as two parameters. In the code I have given “NewExcelFile.xls” as the file name for new file to be created. This code will generate an NewExcelFile.xls […]

Export Servoy Data To Excel

Posted on November 23rd, 2015 by Pradipta Behera

There are different ways to export data from a table in Servoy. Lets start from the easiest one.   1. Using Servoy’s default Export menu : – Servoy has its own menu to perform data Exports and Imports. It supports the xls and text (.csv, .tab, etc) file formats for Exporting and Importing. To use this feature we […]