Export database table into a Excel ark ?

[6291941]

Hi,


Have a little question regarding moving data from a database table to an Excel ark.

Is there any SQL statement you can use to do that ? Export att whole table with it´s columns and data.

The columns in the excel ark (A1, B1, C1, D1 etc) are gonna be replaced with the columns in the database table (id, name, city etc)

Or maybe you can choose the columns you wish to export ?

I´m using the Interactive SQL in Sybase.

Best Regards
Magnus

 

[SQLSister]

Sybase and SQL Server are not the same, I would suggest you ask this question in the sybase forum. In Sql Server you would use DTS or ssis to export to Excel which clearly won't work in Sybase as those tools are native to SQL Server.

"NOTHING is more important in a database than integrity." ESquared