Share via

Process to dump the database in excel

Avyayah 1,291 Reputation points
2021-08-25T22:09:45.763+00:00

Is there a process to export all the tables in a database as an excel file?

SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,406 Reputation points Microsoft External Staff
    2021-08-26T01:58:16.47+00:00

    Hi @Avyayah ,

    Yes, please try below methods.

    1. Use SSMS Import and Export Wizard to export data from SQL table to excel.
      126612-screenshot-2021-08-26-094839.jpg
    2. Use Data Connection Wizard Dialog in excel to import data from SQL table to excel.
      126543-screenshot-2021-08-26-095725.jpg

    Please refer to the blog to get detail steps.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.