View Single Post
  #1 (permalink)  
Old December 28th, 2005, 04:45 PM
x_ray x_ray is offline
Authorized User
 
Join Date: Nov 2005
Location: , , .
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to x_ray
Default transforming data to Excel

hi all,

i have a table in my SQL Server DB, i want to transform the every row in it to an Excel sheet/file,example:

table1 in DB:
fistname lastname DOB
aaaaa bbbb 28/12/2005
cccc dddd 31/2/2006
...

i want it to be in excel for every row:
firstname:aaaa
lastname:bbbb
DOB:28/12/2005
...
i want for every row a new sheet, is this possible?
hope this is clear, thanks