Question How to import and export data?

[RajeshSingh]

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

 

[DavyEFC]

MS Access?

 

[SomeshBatra]

Hi RajeshSingh,
The best option to resolve this problem is ms-excel, because of ms-excel has been provide to export data into many format. But as you have written, you want to import or export .sql file then to do it you must have a sql environment where you could fire sql query for filtration data. MS-SQL has been provide an option to import data and export it into .sql file. Even if you want to use any tool to solve this problem then there are lots of tool in the market which performed Data Conversion task. I had been used a such type of tool (MindStick DataConverter) which helps me lot.

Download Link: MindStick-Unleash Your Imagination

I hope it might be useful for you.