How to import and export data?

#1
RajeshSingh

Posted 10 December 2011 - 07:39 AM

Newbie

Members
1 posts

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
WingedPanther

Posted 10 December 2011 - 04:17 PM

A spammer's worst nightmare

Moderators
16,831 posts

Location:Upstate, South Carolina
Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

The answer is going to depend a LOT on the source format, the types of filtering to be done, the platform you'll do this on, etc.

You can probably create an ODBC connection to a CSV file and do some types of filtering via SQL, but it really depends.

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
SomeshBatra

Posted 12 December 2011 - 01:15 AM

Newbie

Members
1 posts

Hey RajeshSingh,
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. Download MindStick DataConverter tool, its helped in data conversion.

Download Link: MindStick-Unleash Your Imagination
I hope it might be helpful for you.