Solved

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

Posted on 2015-02-24
3
114 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 47

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

823 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