Copy to Excel

[poei]

Hi,

In version 6 I could run a query in the SQL window, right click Copy to excel and excel would open with the result in a work sheet. In version 7 only the headers of the result are take over to excel and no data.

Can someone please help ?

 

[Stew Stryker]

poei,

It works fine for me on V 7.0.1.1066.

Best of luck,

 

[poei]

Seems to be a excel limitation. Table have 300 colums.

Smaller Selecting works fine.

 

[Robert_G]

Originally posted by poei:
Table have 300 colums.

You meant rows, right? Otherwise...

btw: Copy 2 XL copies only the selected cells, so if you accidently selected the 1st row, you'll only see that row...

 

[Stew Stryker]

Robert,

I think poei's talking about the limit in Excel of 256 columns.