Hello Everyone, I have been facing a problem since last two days, actually i want to import some data from a file (file can be csv, txt, sql, xls etc) and after some filtration, export it into csv file. Basically i want to know whether a tool which provides an environment to import different types of file or data where we can perform filtration of data with the help of sql query and then data could be save into file(file can be csv, txt, sql, xls etc). Please give me your valuable suggestion. Thanks in advance!!
2 options spring to mind: 1) SQL Server or Express using SSIS / DTS to import / export 2) MS Excel, although filtering would be via Excel functions and not SQL queries
Hey AnkitaSingh, I am agree with CrystalCMS, he is absolutly right but yet if you want to use a tool then you can use MindStick DataConverter tool. It is free charge of tool so you can easily download and used it. Download Link: http://www.mindstick.com/Product/ProductDC.aspx I hope it might be useful for you.
