Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

Import and Export Data

- - - - -

  • Please log in to reply
3 replies to this topic

#1
BhupendraSingh

BhupendraSingh
  • Member
  • 2 posts
  • OS:Windows 7 x86
  • Country: Country Flag
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!!


How to remove advertisement from MSFN

#2
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,385 posts
  • OS:none specified
  • Country: Country Flag
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...et/Record02.htm
to do an intermediate conversion.

jaclaz

#3
BhupendraSingh

BhupendraSingh
  • Member
  • 2 posts
  • OS:Windows 7 x86
  • Country: Country Flag
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.

#4
CoffeeFiend

CoffeeFiend

    Coffee Aficionado

  • Super Moderator
  • 5,399 posts
  • OS:Windows 7 x64
  • Country: Country Flag

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.
Coffee: \ˈkȯ-fē, ˈkä-\. noun. Heaven in a cup. Life's only treasure. The meaning of life. Kaffee ist wunderbar. C8H10N4O2 FTW.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN