February 13, 2009 at 6:20 am
I want to export database from Sql server 2005 to Excel. Is there any way to do so. Also database is with .bak extention so is there any possibility to convert it into .sql or .csv format.
February 13, 2009 at 6:40 am
you cant convert a .bak into csv, xls or anything.
The way to export your data to excel is to use SSIS to build an export package from SQL server, there is even an import/export wizard to get you started.
February 13, 2009 at 7:04 am
I have never exported an entire database, but I have individual tables using Enterprise Manager.. drill down to your database, and right click on Tables goto All Task > Export Data..
1st screen is just a splash screen
2nd screen - Choose your data source
3rd screen - Choose your data destination (make the type excel and name your file here)
4th screen - Specify Table Copy or Query (I have used Copy Tables & Views)
5th screen - Select Source Tables & Views (as mentioned before I have only done single tables)
6th screen - Save, schedule and replicate package (I have always used "Run immediately")
7th screen - Completing Wizard splash screen (just hit "finish")
Hope this helps..
Later - SgtSnafu
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply