export table to excel file

#1

hi,

is there a way to get the data of a table exportet to excel?

thanks

#2

In both SQL Server 2000 Enterprise Manager and SQL Server 2005 Management
Studio, right-click on the database with the table, choose All Tasks, Export
Data or Import Data, then follow the wizard. When it asks you for the
destination choose Excel and then type in a file name. You can't go wrong!

Charles Kangai, MCT, MCDBA

"florian" wrote:

Quote:

hi,

is there a way to get the data of a table exportet to excel?

thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

export table to excel file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

export table to excel file - 08-11-2006 , 08:31 AM

RE: export table to excel file - 08-11-2006 , 02:28 PM