 | |
Transposing Excel file using ActiveX Transformations
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Transposing Excel file using ActiveX Transformations -
01-19-2005
, 10:53 AM
#2
| |||
| |||
|
|
Normally when you read in an Excel file through DTS you read it in by row. I have a file that is setup as a cross tab report that I need to read in. This is how it is in the spreadsheet: Jan 05 Rebate Rate .017 Int Rate .010 In the database I want it like this Jan05 Rebate Rate .017 Jan05 Int Rate .010 Can somebody please get me started on the code for this? I would appreciate it. THANKS |
#3
| |||
| |||
|
|
Andy, Transposing would be: Rebate Rate Int Rate Jan05 .017 .010 Ilya "Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote in message news:CE0EFC3A-D488-4EE5-B7FA-2FAFF7D16548 (AT) microsoft (DOT) com... Normally when you read in an Excel file through DTS you read it in by row. I have a file that is setup as a cross tab report that I need to read in. This is how it is in the spreadsheet: Jan 05 Rebate Rate .017 Int Rate .010 In the database I want it like this Jan05 Rebate Rate .017 Jan05 Int Rate .010 Can somebody please get me started on the code for this? I would appreciate it. THANKS |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.