BhupendraSingh Posted December 7, 2011 Share Posted December 7, 2011 Hello,I'm using Window 7 operating system. I have a problem; actually I want to import excel data with some filteration and then export it into csv file, I don't have idea that how to do it ; Is this possible? if it is possible then tell me, is there any tool which could performed this task.Please give me your valuable suggestion. Thanks in advance!! Link to comment Share on other sites More sharing options...
jaclaz Posted December 7, 2011 Share Posted December 7, 2011 You do not "export" data in .csv format, you actually "Save as" .csv the actual spreadsheet (single sheet).About importing it greatly depends on HOW EXACTLY the soource data is formatted, no way to give you any "meaningful" answer without some DETAILS.Excel has a built-in import filter for either "fixed length" or "delimited" data, but it's behaviour may be influenced by a number of factors, including repeated separators and what not.Also in some cases Excel "automagically" determines *something* to be text or date or number and makes the importing procedure more difficult/prone to error.You may need to use a "more dedicated2 program such as:http://record-editor.sourceforge.net/Record02.htmto do an intermediate conversion.jaclaz Link to comment Share on other sites More sharing options...
BhupendraSingh Posted December 8, 2011 Author Share Posted December 8, 2011 Actually it is not my exactly problem, I want a such type of tool which import any type of file such as .csv, .txt, .sql etc. and export that data in any file extension whatever you want.Please help me. Link to comment Share on other sites More sharing options...
CoffeeFiend Posted December 8, 2011 Share Posted December 8, 2011 import any type of file such as .csv, .txt, .sql etc. and export that data in any file extension whatever you want.So it only has to be able to read any format and save in any format? You should have said so sooner, we'd have let you know that magic software doesn't exist?If you set the bar a little lower, than Excel will do just that (if you know how to use it, much like jaclaz said) with most common formats (or some other programs, for specific given tasks). Anything beyond that will pretty much require you to write your own specialized software for specific jobs. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now