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

Posted on 2009-12-17
Last Modified: 2012-05-08
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.
Question by:bpbarberhelp
    LVL 26

    Assisted Solution

    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

    LVL 13

    Expert Comment

    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.

    Author Comment

    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)

    Author Comment

    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.
    LVL 26

    Expert Comment

    you should probably getting some error messages during exporting data. Can you provide the error messages...

    Author Comment

    The only message I got is the one I posted two posts back.
    LVL 16

    Accepted Solution

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now