Data Export and Import

SOLVED Discussion in 'Software' started by Golu Singh, Dec 7, 2011.

  1. Golu Singh

    Golu Singh

    Joined:
    Dec 7, 2011
    Messages:
    3
    Likes Received:
    0
    Hello Guys,

    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 and 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!!
     
    Golu Singh, Dec 7, 2011
    #1
    1. Advertisements

  2. Golu Singh

    S Walch MAME 0.64 :) VIP Member

    Joined:
    Jun 2, 2003
    Messages:
    1,026
    Likes Received:
    14
    Location:
    Manchester
    What you trying to import the excel data into?

    If you have Microsoft Office excel, Excel itself can save in .CSV format. You just have to go to the Windows Button/File, and choose .CSV from the dropdown Save as type box.

    If you could let us know what programmes you're using, it'd help us a lot :)
     
    S Walch, Dec 7, 2011
    #2
    1. Advertisements

  3. Golu Singh

    Golu Singh

    Joined:
    Dec 7, 2011
    Messages:
    3
    Likes Received:
    0
    Actually I want to import excel data into sql server and after some modification i could save into either in csv, sql, html or txt file. So i want to know, is there any tool is available like that.

    Thanks for Quick Reply!!
     
    Golu Singh, Dec 7, 2011
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.