SELECT INTO OUTFILE?

Hot Topic

Transformation Service question about de_dup process.
Authentication an application using Windows Integrated Authentication
SQL 2005 woes
I'm Stumped (Complex Joins With and Updates)
What is this?
Complex join
Getting error in SQL Server Destination
Multilingual report ?
How can I restore a database from a UNC?
DATABASE AGE

SQL Server

setup.exe /qb REMOVE=ALL instancename=test
Advice on a process
VS2005 / NonExecuteQuery / SQLDataSource
Fit Table on one page if possible
Problems Executing Stored procedure OLEDB
Restoring 20 gb .bak to new server
Two Phase Commit
Stored Procedure
RowSampling: How to dynamically populate the Number of Rows
SUM problem in SSRS 2005 report

SELECT INTO OUTFILE?

Hi,

how do I redirect the output from a SELECT to a text-file, or Excel-file

It is possible in MySQL, but what about Transact-SQL

Thanks

Answer this question

SELECT INTO OUTFILE?

  • Suprotim Agarwal

    Thanks!

    Sten-Gunnar

  • Aaron Oneal

    Thanks!

    Sten-Gunnar

  • malangpc

    YOu have to use the OPENDATASOURCE method or a linked server to insert data in another destination than the local SQL Server. More information (including a sample can be found in the BOL)

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • mostaf

    If you put your select statement in a file and use osql (SQL 2000) or sqlcmd (SQL 2005) you can direct your output to a text file.

  • SELECT INTO OUTFILE?
Answer this question