SQL Excel

Hi!

First of all thanks for this great add-in. really useful, pretty fast.

i have a question though. after starting a query i get a list of my results. is it possible using this add-in to pivot/crosstab this result? To clarify: The output is like follows (three columns):

col1 col2 col3
AAAA aaaa 27
AAAA bbbb 12
AAAA cccc 47
AAAA dddd 55
AAAA eeee 32
BBBB aaaa 12
BBBB cccc 22
BBBB dddd 34
...
CCCC aaaa 11
...
DDDD aaaa 33
....
EEEE aaaa 23

The desired Excel format/output would be (excel column "A" would be the results from col1 from the example above, column "B" would contain the results from col3, "grouped" by the label of col2):

1 | A | aaaa | bbbb | cccc | dddd |
--|-------|------|------|------|------|
2 | AAAA | 27 | 12 | 47 | |
3 | BBBB | 12 | - | 22 | |
4 | CCCC | 11 | | | |
5 | DDDD | 33 | | | |
6 | EEEE | 23 | | | |

I hope everything is clear ?
I think there is a feature like that on SQL server 2005 called "pivot"- unfortunately i'm still running 2000 and can't upgrade . Any suggestions?

Thanks in advance
Harald

Hi!

Thanks alot for signing up on the site.

Sorry but that is not possible at the moment with the addin. The addin is moving in this direction but at the moment and for the next while all you can do is use the available SQL commands for the database system you are using.

All I can suggest at this point is that you write a routine in VBA to process the imported data. Or you could upgrade to SQL 2005 like you say...

Sorry for that. Please feel free to post up other feedback if you think of something as it is very helpful to keep the addin moving forward. Some things are easier to implement than others..

Thanks again and have a nice evening. Al