Hi,

Thanks for the reply, i'm on 2008 sp3

I have tried the connection through excel and it still shows the same amount of records as in the browser which is wierd.

I know there are 318000 records but it's only showing 240000.

thanks

ld