Hi,

Did you get anywhere with this,

I am trying to get sqlserver 2005 to import sales_ledger from sage

and it only returns 512 of 613 records. no explanation why, no errors.

by the way, Excel manages to read all 613 records, using msquery.

so im assuming its an issue with SQL Servers openrowset command??

Regards,

Russ