How to import and export data?

[JeetVerma]

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!!

 

[PiyushChandra]

Hi JeetVerma,
The best option to resolve this problem is MS-Excel and MSSQL Server. Because of they have facility to import and export data in csv file yet if you want to use any tool to resolve this problem then there are lots of tool in the market which performed data conversion task. MindStick DataConverter is nothing more than data conversion tool. It is free charge tool so you can easily download and used it.

Download Link: http://www.mindstick.com/Product/ProductDC.aspx

I hope it might be helpful for you.