Copy to Excel......

[RobertK]

6.0.6.947

In SQL Windows, right-clicking the result and "Copy to Excel"....Excel always dispalys this annoying crap:

Is there any way to stop this ?

thanks

 

[Marco Kalter]

I'm not familiar with this error. Which Excel version are you using?

 

[braykov]

I'm not sure if this is the same error but there is a restriction with the length of text a cell in EXCEL can hold.
If it exceeds it, an error is thrown.
This happens when exporting from PLD also creates a second Sheet with the SQL text thrown in the first cell.
Try copy & paste with your SQL into an empty XLS cell and see if throws an error.
Actually it would be nice if PLD had the feature to send the sql rows in different cells.

 

[RobertK]

Originally posted by braykov:
I'm not sure if this is the same error but there is a restriction with the length of text a cell in EXCEL can hold....

it happens ALL of the times

 

[RobertK]

Originally posted by Marco Kalter:
I'm not familiar with this error. Which Excel version are you using?

 

[Marco Kalter]

Strange. As a test, can you try this with the trial version of 7.1? You can download it here . Make sure that you install it in a separate directory from 6.0.6.