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

msql datenbank table print

I have a MSSQL Server and many databank .
I would like to import one of my databank all tables to ms excel.
Datenbank name is "proco" and including all tables that database import to ms excel.

how can i do that?
0
apollo-13
Asked:
apollo-13
  • 2
  • 2
2 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>databank
I'll bite.  What's a 'databank'?
0
 
apollo-13Author Commented:
database
0
 
apollo-13Author Commented:
zz
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
To export one table into a spreadsheet, in SSMS right-click on Database, Tools..., Export Data, and follow the prompts.  This creates an SSIS package that can be re-used.

To export all tables into a single Excel spreadsheet, one table for each tab, don't know the answer to that one other than using SSIS to do a data flow for each table, into a separate tab.  I'll take a step back to encourage other experts to respond.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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