469,126 Members | 1,271 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

How to copy column(s) from one excel sheet to another using sql server.

Hi,

Does anyone have an idea that how to copy column(s) from one excel sheet to another sheet using sql server.

Thanks for your help in advance.

-Deven
Feb 19 '09 #1
2 3278
Which version of SQL Server are you using, and are you copying into a new excel file or are you trying to copy into an existing excel file?
Feb 20 '09 #2
ok, my SSIS package (sql server 2005) transfers data in excel 1 and in excel 2 and I want to add column either in excel 1 or in excel 2 like following,

excel 1
A1 B1

excel 2
C1 D1

what want is
either excel 1
A1 B1 C1 D1

or excel 2
A1 B1 C1 D1

Thank you,
Deven
Feb 23 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Jerry J | last post: by
9 posts views Thread by smk17 | last post: by
7 posts views Thread by Vanessa | last post: by
13 posts views Thread by chuckie_9497 | last post: by
1 post views Thread by =?Utf-8?B?TGFtaXM=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.