Issues of import and export data

[PraveshSingh]

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

[Brainarts]

Hi,

I've been placed in front of the same problems months ago and found that the best way to process back and forth with the data (Import, Transform, Filter) was to use MS SQL Express or Full Featured MS SQL Server if you have access to it.

Alternatively you can use Access to proceed the same way.

Best Regards

[BhupendraSingh]

Hi PraveshSingh,

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 to filtration data. There are lots of tool in the market which performs data converting task. I have used a such type of tool since last month.

I don't have remember the exact download path of this tool, so you can search over the internet.

I hope it might be resolve your problem.

[seostudent]

That answer provided by BhupendraSingh was somewhat the answer I thought about providing, but wasn't sure if I was right or not. Basically you have to have a program that is capable of importing or exporting the file extensions you would like to use?