|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Friday, June 26, 2009 8:23 AM
Points: 115,
Visits: 318
|
|
Hi guys...
A big favor, I need to export my database into excel format, I have been trying using SQL Management Studio but it failed....please any other tool I could use to perform this task?, or some query...please?... I need to get that shortly...
Thank you.
OS windows 2003
SQL Server 2005 EE
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, June 30, 2009 12:01 PM
Points: 16,
Visits: 124
|
|
You can export the Tables/Views data from database to excel file.
For this you have to rightclick database and select export data.It will ask you the source and destination..after that you can select whatever(Tables/Views) you want..
Hope this would help...
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 89,
Visits: 495
|
|
How big is the database? There's always cut'n'paste :D from the results window. Or saving to a text file and importing the results ;)
I've found the Export Data Wizard to work ok in the past, it even lists Excel (with an ancient Excel icon) as one of the export options.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 8:23 AM
Points: 115,
Visits: 318
|
|
I tried that wizrd export table/views...select the ones I need, in this case the whole database...but when I start with the exporting...it failed with : " Failed with the following error :"The microsoft Jet database engine could not find the object 'asass'. Make sure the object existes and taht you spell its name and path name correctly. posible failure reasons : Problems with the query, 'Resultset' property not set correctly, parameters not set correctly or connection not establish'
I test the connection..and it passed
I don't kknow what else could be...
database size 1GB
Please help..
Thank you.
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 10:38 AM
Points: 1,275,
Visits: 3,218
|
|
You can use SSIS to do this.
though if your databsae is large then you are going to run into trouble exporting to excel 2003 as excel 2003 and earlier versions only have 65,536 rows.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 8:23 AM
Points: 115,
Visits: 318
|
|
If so, please would you mind recommending me another tool, or another way to do it, please?..I really need to export this..and I am getting crazy.
Thanks.
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Yesterday @ 8:11 PM
Points: 606,
Visits: 794
|
|
You do not need another tool - follow advice above its all there in SSMS.
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 10:38 AM
Points: 1,275,
Visits: 3,218
|
|
Junior_DBA (10/1/2008)
If so, please would you mind recommending me another tool, or another way to do it, please?..I really need to export this..and I am getting crazy.
Thanks.
export the DB to a CSV file using SSIS then you can use these files to populate excel if needed.
SSIS even has a wizard to get you started, though it is very similar to the one in SSMS
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Yesterday @ 8:11 PM
Points: 606,
Visits: 794
|
|
In Excel 2007 you can link directly to the SQL also.
Click on Data Connections.
Click on properties and set up your defintion.....
Viola no export - direct access ....to SQL.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 26, 2009 8:23 AM
Points: 115,
Visits: 318
|
|
Hi Guys...I followed your advise, and I just get the .dtsx file, but now how can I do to export to excel?
Please any help???
Thank you.
|
|
|
|
