MS SQL export / import data

[Akosko]

Hi there,

I need to dump some data from a db by using MS Query. I noticed couple of issues during my attempts to do so. However I tried to run a query like:

SELECT table.column
INTO OUTFILE '/tmp/result.txt'
FROM table

which generated an error message:
Didn't expect "OUTFILE" after the SELECT column list.

Next I tried was:

SELECT table.column
FROM table
INTO OUTFILE '/tmp/result.txt'

generated another error:
Syntax error in FROM clause.

I also tried to define not only relative path to te result file but absolute path as well but it didn't help me a lot :-(
Could anybody help me what is theright syntx of this statement or is there some special way of MS Query to dump or export or write rows from the database into a file ?

Every suggestion will be higky appreciated

Tanks in advance

[amas]

why not try select col1name1, colname2, ... from tablename
then highlight the results, copy it and paste in a text editor eg notepad.
You can then save it and eventually open with excel.