Posted by: Charles Maitland | Friday 24 February, 2006

Copy and Paste SQL Server 2005 to Excel

We have just found a really strange effect.

In SQL Server 2005 we ran this query to get a quick dump of cost centres for another application:

Select Distinct CostCentreCode,CostCentreName


The results were reported as 5021 rows. I Selected all these copied them and pasted them into Excel.

Imagine our surprise when in Excel only 3673 rows appeared!

I have no idea why. I can only think it may be a limit in the clipboard buffer.

This is potentially a vey dangerous situation. If it was not for my collegues sharp eyes it could have gone undetected till go live.

Does anyone have any ideas why this happens?


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s