PDA

View Full Version : Saving SQL Tables as xls



aidanmaz
26-01-2010, 02:20 PM
Im trying to save a particular table in SSMEE into an xls, as i need the information from the table to put into another database. Im not an sql person, and cant seem to do it. After opening SSMEE i double click databases, then i double click pawnmaster then i doubleclick tables, i need the items.dbo and pawn.dbo, so i right clcik one of them and click open table. The information displayed in the right pane is the info i need put into excel, how do i get it from here to excel?

inphinity
26-01-2010, 02:39 PM
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

aidanmaz
26-01-2010, 02:47 PM
Unfortunately that site looks helpful but i have no idea what any of it means, I was just told (being the IT guy) to take the information out of sql and save it xls.

somebody
26-01-2010, 06:49 PM
You can just copy/paste the data out of the table into Excel (click on the top left corner of the table to "select all").