Solved

I need help exporting SQL Server data to a tab delimitted file

Posted on 2015-02-24
3
113 Views
Last Modified: 2015-03-29
I experts,
I use a few select queries in SQL Server 2008 R2.  I want to export the query results to a tab delimitted file.  How can I do this?  Thank you very much in advance for your help.

mrotor
0
Comment
Question by:mainrotor
3 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 200 total points
ID: 40628267
Execute the query in SQL Server Management Studio, then right-click the result grid and select "Save Results As" from the context menu. TAB delimited text is one of the available file formats.
0
 
LVL 15

Assisted Solution

by:deepakChauhan
deepakChauhan earned 200 total points
ID: 40628452
If records count is very high, you can use Import/ Export Wizard. Just right click on database and click on export data.... , next all steps are self-explanatory.
0
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 100 total points
ID: 40633423
Yes, I'm also with the Export data option. Instead of choosing a table you need to provide the query that you want.
TaskMenu.PNG
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now