February 19, 2009 at 3:37 am
Hi, Good day
How to export sqlserver 2005 database table to excel sheet
Eg:-My Database name is PRINCE (Sql server 2005), it having tabled called EMP
Its having 20000 records approximately, how export this EMP table data into excel sheet
Thanks & Regards
rclgoriparthi
February 19, 2009 at 6:13 am
Dear friend,
you can use excel's feature of import data from data section.
there u can write selecte satement s and can retrive the data.
Mithun
February 20, 2009 at 3:37 am
For a once only export use SQL Server Import and Export Wizard:
Right Click on the Database then:
Tasks->
Export Data->
Next->
Data Source = PRINCE ->
Next->
Destination = Microsoft Excel; Excel File Path = Browse "Your File Name Here"
Next->
Next->
Source = EMP->
Next->
Next->
Finish
February 20, 2009 at 10:47 am
Why did you post a question related to SS2K5 in this SS2000 forum ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply