Exporting to Excel - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Exporting to Excel

Author

Topic

davidwhyte
Starting Member

13 Posts

Posted - 2007-04-03 : 07:15:05

Hi,

Ive installed and imported a db into SQL2005 Express. I now need to export the db to an excel file but I cannot find the import/export feature. Ive tried navigating to the db within the SMSE inteface and right clicking but there is no options available to carry out the task.

Any ideas guys, stuck on this one

NeilG
Aged Yak Warrior

530 Posts

Posted - 2007-04-03 : 07:44:46

There isn’t a way of you exporting from SQL server only the BCP command that just exports the table or query to a text file, personally If I was trying to import some data from SQL server into excel I would utilise excel for example one simple way is to

Write the query your require eg

Select Firstname, Lastname
From Customers

From here open the Excel program and drop down the ‘Data’ menu, then select the ‘ Get external data ‘ option and then the ‘ run database query ‘ option, connect to the SQL Server that hold the data and use the query that you have already wrote in the query box. This will then automatically run in the data that you require into Excel spreadsheet for you and you can format from there. Otherwise I would use VBA programming to make it more automatic to run on opening and retrieve the most recent data, but this is only really an option if you need to use the report on a regular basis.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-04-03 : 08:23:07

http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

davidwhyte
Starting Member

13 Posts

Posted - 2007-04-03 : 11:52:01

In the old Enterprise Manager, there was an option to export the db just by right clicking the db you wanted to export, does this function no longer exisit in SMSE? Spirit1, thanks for you link but that is way above what Im able to do with SQL since Im a newbie.

DW

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources