• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Sign in to follow this  
Followers 0
BhupendraSingh

Import and Export Data

4 posts in this topic

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

0

Share this post


Link to post
Share on other sites

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.htm

to do an intermediate conversion.

jaclaz

0

Share this post


Link to post
Share on other sites

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.

0

Share this post


Link to post
Share on other sites

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.

0

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.