| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 106861 | 2010-01-26 02:20:00 | Saving SQL Tables as xls | aidanmaz (7180) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 851948 | 2010-01-26 02:20:00 | 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? | aidanmaz (7180) | ||
| 851949 | 2010-01-26 02:39:00 | www.sqlteam.com | inphinity (7274) | ||
| 851950 | 2010-01-26 02:47:00 | 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. | aidanmaz (7180) | ||
| 851951 | 2010-01-26 06:49:00 | 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"). | somebody (208) | ||
| 1 | |||||