Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GauravYadav
Starting Member
1 Post |
 Posted - 2012-02-06 : 10:13:16
|
| Hello Everyone,I'm facing problem since last night, actually I want to import text file data in sql file and perform some filtration in it and then after export this data in many extension file such as html, mdb, xls and txt etc. So I want to is there any option which perform such kind of actions, and is there any third party tool which perform such type of actions.Please resolve my problem. Thanks in advance!!gAURAV yADAV |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-06 : 12:07:11
|
| you can use openrowset------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
JayPrakashSharma
Starting Member
1 Post |
Posted - 2012-02-07 : 10:54:21
|
| Hi GauravYadav,SQL Server provides an option to import text file, to do it you have to use bulk query command with of help of this you could import data from different file extension such as .csv, .txt, .xls file etc. Now you could apply filtration query on this file and if you want to export it different file extension, you have to select 'Result to Text' (In case of text file format), 'Result to File'(In case of any file format). But if want to use any third party tool to perform such kind of actions, there are lots of tool in market to perform such kind of task like MindStick DataConverter, AutoConverter etc. I had used MindStick DataConverter to perform such type of actions. MindStick DataConverter Downloads Link: http://mindstick.com/Product/ProductDC.aspxI hope it might be resolve your problem.JayprakashSharma |
|
|
|
|
|
|
|
|
Issues With Import and Export