Solved

msql datenbank table print

Posted on 2013-12-18
5
254 Views
Last Modified: 2013-12-20
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
Comment
Question by:apollo-13
  • 2
  • 2
5 Comments
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 500 total points
ID: 39728414
>databank
I'll bite.  What's a 'databank'?
0
 

Author Comment

by:apollo-13
ID: 39728511
database
0
 

Author Comment

by:apollo-13
ID: 39728513
zz
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39730171
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

920 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

13 Experts available now in Live!

Get 1:1 Help Now