Exporting from SQL 2005

[Skyline]

I;m running SQl2005, and wondering how I can export fields, such as STD_ITEMS to Excel?

Was easy with 200, as you culd right click > All Tasks and export.

But can't seem to find the option using SQL Express and 2005?

 

[Zen2]

Type dtswizard in either a command prompt or Run dialog box

 

[Skyline]

Doesn't work :S

 

[jasper]

open the table you want, to view it in the right hand pane, then click the top left corner of the opened table to select all (as you would with excel) right click and copy, open excel then paste, i think,, dont have it installed any more.

 

[Zen2]

i copyd that from here half way down the page is 2005

http://www.mssqltips.com/tip.asp?tip=1055

Dont have it installed to check though sorry.

 

[Skyline]

open the table you want, to view it in the right hand pane, then click the top left corner of the opened table to select all (as you would with excel) right click and copy, open excel then paste, i think,, dont have it installed any more.

That works cheers. Would it work to import too?

 

[jasper]

i cant honestly remember, best thing to do is to make a backup of your db, then restore it to a different named db to mess and try things out with first.