How to import data from two table to single excel sheet?

Question

1.00/5 (2 votes)

See more:

SQL-Server

How to import data from two table from SQL Server into a single excel sheet?

Posted 11-Sep-13 3:23am

Aboobakkar Siddeq D U

Add a Solution

Comments

Sergey Alexandrovich Kryukov 11-Sep-13 11:11am

http://whathaveyoutried.com? Why it seems to be a problem?
—SA

Sergey Alexandrovich Kryukov 11-Sep-13 11:18am

And this is not "import", this is "export"... :-)
—SA

Aboobakkar Siddeq D U 12-Sep-13 1:00am

ok thanks a lot for your information, i'm a fresher so i don't know much about development. Please tell me how to Export data from 2 table into a single excel sheet at a time?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-09-11T05:16:00

First of all, you should understand that this is not a problem at all: as you don't need to support the tables in an Excel sheet and only need the export, you can place any number of tables on the single sheet: each table have a finite size, so you can put, say, two table in different location of the sheet. If you, say, shift second table on the right of the first one, you can even grow them later, as the tables have fixed number of rows.

For creation of the Excel files, you can either use Microsoft Word interop (it requires Excel to be installed) or Open XML SDK:
http://en.wikipedia.org/wiki/Open_XML[^].

As you did not share information on your programming language, platform and other detail, that's all.

—SA