[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 962
  • Last Modified:

Exporting tables out of SQL Server 2008 to Excel or any easily modifiable format

I am trying to find the easiest way to export tables out of a SQL db into Excel. I don't know the SQL language that well, so just looking for a point and click type scenario if one exists.
2 Solutions
its very easy by sql server management studio.
connect to the sql server by using the sql server management studio.
in the object explorer right click on the database that contains the tables that you want to export.
choose Tasks -> Export Data
there will a wizard be open...
follow the steps and choose the excel as destination...
thats all

Import, Export wizard is the easiest way to export the data into excel. All you need to do is to connect to Management Studio --> Expand Databases --> Right click your database --> Tasks --> Export --> In the Export wizard, select your database and table as the source and the excel sheet as your destination. After which, just go through the simple steps and you should be able to get the data in excel.

Please revert in case of any queries.
bpbarberhelpAuthor Commented:
Great, now during the export, I get this:

- Executing (Warning)
Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

bpbarberhelpAuthor Commented:
Sorry, I should probably add that it never completes the export. And, if I look at the file it just has the column names even though it says 1426 rows transferred.
you should probably getting some error messages during exporting data. Can you provide the error messages...
bpbarberhelpAuthor Commented:
The only message I got is the one I posted two posts back.
Jerry PaladinoCommented:
Excel provides facilities to connect to SQL Server and pull data from tables or views into an Excel worksheet.
In Excel 2003 - Data Menu / Import External Data / New Database Query.  
This will allow you select an ODBC driver to connect to a number of available databases (including other Excel files).   A SQL Server driver should be included with the Office suite.  I suggest unclicking the Query Wizard checkbox on the first dialog box.  MS-Query will be displayed and allow you to select your database table.
In Excel 2007 - Data menu / Get External Data(ribbon) / From Other Sources / From SQL Server.
A wizard will ask for your server name and associated information required to connect to the database.
I do not have access to SQL Server so I most likely cannot provide additional SQL Server specific answers.  I connect to MS-Access the same way and have attached some PDF files that will provide graphics on the Dialogs you will see and a view of MS-Query.
The data connection to the database can be refreshed at any time.  This is not a one time import to Excel.  Right Click anywhere in the table of imported data and select REFRESH on the sub menu to refresh the data from your SQL Server table or view at any time.


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now