Post reply

export data from sql server to excel

  • July 22, 2015 at 6:36 am

    #300563

    Hello, I faced with an issue: there is a need to export data from SQL Server to excel. Can you help me? How to do this? I'm on SQL Server 2008 R2

  • July 22, 2015 at 7:01 am

    #1814092

    Would the Import/Export Wizard could help you? It uses SSIS to export the data and you can save the package to edit it or run it anytime.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 22, 2015 at 7:04 am

    #1814093

    As mentioned prior, use the import-export wizard, or run the results to grid and if its not a lot and copy & paste them into the spreadsheet.

  • July 22, 2015 at 7:21 am

    #1814100

    Thanks for replies. I would specify my question... I need to export data from .bak file any easy way.

  • July 22, 2015 at 7:52 am

    #1814115

    Have you tried restoring it first?

  • July 22, 2015 at 7:57 am

    #1814117

    If you have a .bak file, you need to restore the file into a database, as you only have a backup file.

    https://msdn.microsoft.com/en-us/library/ms177429.aspx

    After restoring your database, you need to define what are you going to export to Excel and export it.

    There are probably some 3rd party tools that can use the .bak file directly, but you might need to pay for them.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 22, 2015 at 8:02 am

    #1814120

    Thanks a lot. I didn't restore .bak.

  • July 22, 2015 at 8:38 am

    #1814130

    As Luis C. wrote, you cannot restore the data from a .bak file to Excel directly, but you have to restore it on your database server first. During this process of restoring the database backup file, the table structures will be created and data will be inserted in them, depending on what type of backup file it is. In order to restore a .bak file you can use SQL Server Management Studio (SSMS) and you have to make a few steps. This steps described in an article with details http://sqlbak.com/blog/export-data-from-a-bak-file-to-excel/[/url] Hope it would be useful

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply