CopyFromRecordset Method to Excel sheet producing duplicate rows?

Hi,
New to the forums, kept meaning to join up but never did, I suppose it's the old story of not joining til I have a question!!

I just had a quick search on the following question, but didn't find anything.

I have upgraded from SQLServer 2003 to SQLServer2005 last weekend.

I have spreadsheets that use the following VBA structure to download data:
-----------
Set aRS = New Recordset
SQLSTring = "SELECT * FROM Table" Very simple query

aRS.Open SQLSTring, aDBConnection, adOpenKeyset, adLockOptimistic
aRange.CopyFromRecordset aRS
aRS.Close
------------


Which is the straight forward method.

Now I get duplicate lines in my excel sheet download which I did not get previously.

If I run the query in my query analyser it works fine without duplications(this is the work around at the moment).

I am stumped for the moment as to what errors I could have??
Any ideas greatly appreciated!!