Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • 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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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