Jump to content

Issues with Import and Export data form different file


Rishi
 Share

Recommended Posts

Hello Everyone,

I'm troubling with one problem in SQL Server, actually I want to import data from different file format such as txt, csv, sql etc and apply some filtration in it. After that export it into different file format. So I want to know whether any third party tool which performs such kind of functionality. Please give me your valuable suggestions.

Thanks in advance!

Link to comment
Share on other sites

Welcome to the forums Rishi. When you say "SQL Server", I'm thinking you are talking about Microsoft SQL Server, but let me know if I've misunderstood. I've never used SQL Server, so don't know what tools may be available for it, but I have to imagine there would be something like PhpMyAdmin. I think that a tool like that would do exactly what you are asking for.

Link to comment
Share on other sites

Hello Rishi,

Microsoft SQL Server has an option to resolve this problem, if you want to import data form different file format, you have to use BULK Query Command. With the help of this you could import data from different file format. But in case using third party tool, there are lots of third party tool is available in market to resolve this kind of problem. Some famous tool are MindStick DataConverter, AutoConverter etc. MindStick DataConverter is a free charge tool so you could easily download and used it.

MindStick DataConverter Downloads Link: http://mindstick.com/Product/ProductDC.aspx

I hope it might be useful for you.

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...