ADO Issue Post SP1 in Excel 2010

[VipulGupta]

Dear Friends,

I have an application (originally developed in Excel 2007) which uses ADO to read data from another sheet within the application file.

When used in Excel 2010 environment, everything in the file worked well till I installed Office 2010 SP1. Post installation, the ADO Output is incorrect through I am not getting any errors.

I have tried playing with references in the file but nothing seems to work.

Has anyone else experienced this issue and is there a fix? I can provide code snippets if required

 

[Norie]

As well as code snippets can you explain how the output is wrong, perhaps with some sampel data.

As for SP1, I've not heard of any problems with it or had any myself.