sql server -- result wants into txt file or exel file

[sachin28880]

hi all

i want sql query result into text file (by using query) can any one tell me...

like this Select * from employee where empname='sachin ' to 'c:\result.txt'

from sachin shah

[bwestover]

hi all

i want sql query result into text file (by using query) can any one tell me...

like this Select * from employee where empname='sachin ' to 'c:\result.txt'

from sachin shah

You should be able to set 'Results to File' in Query Analyzer. To do this in Query Analyzer click Query->Results to File, or press Ctrl+Shift+T.

Then when you execute your query, it will go to a file of your choosing.

The other way is to simply copy and paste the results grid to Excel.

What version of SQL are you running? Are you trying to do this once or twice or are you trying to write a program that does this?

[sachin28880]

You should be able to set 'Results to File' in Query Analyzer. To do this in Query Analyzer click Query->Results to File, or press Ctrl+Shift+T.

Then when you execute your query, it will go to a file of your choosing.

The other way is to simply copy and paste the results grid to Excel.

What version of SQL are you running? Are you trying to do this once or twice or are you trying to write a program that does this?

hi

i know these thing, but i want the query....

i am using sql 2000...

[azimmer]

hi

i know these thing, but i want the query....

i am using sql 2000...

unfortunately it isn't that easy; in fact a simple query can hardly do it

one way to go is to build a DTS package (if you start from Enterprise Manager / Data Transformation Services, it is fairly straightforward , though not necessarily simple)

another possibility is to do it the other way round: via ODBC from Excel (it doesn't work for TXT)

[azimmer]

unfortunately it isn't that easy; in fact a simple query can hardly do it

one way to go is to build a DTS package (if you start from Enterprise Manager / Data Transformation Services, it is fairly straightforward , though not necessarily simple)

another possibility is to do it the other way round: via ODBC from Excel (it doesn't work for TXT)

oh yea', and one more, maybe the best fit to your needs: OPENROWSET