I want to export some tables into one single excel file (multi-sheet) in sql server 2000. I can generate output excel file. however I dont want it shows the column name of the table. can any one halp me? Thanks in advance.

what way are you taking for export? DTS?Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

yes DTS

If you can use a SSIS package to do it (2005 or later - but you can still use this to connect to 2000 database, there is an option when creating connection manager to choose if you want the first row to be the column headings or not. Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

Dear I think you can do it only by excel create one connection with sql server by data menu and select your table and and if you want to add one sheet or next sheet you can choose Thanks Ramesh Rathod

Can anyone suggest a automatical method to remove the column header? I really need your help. Thanks very much.