Perform calculation in Excel and store in Access
 

Hi Geeks,

To overcome the excel record limitations i want to move data from excel to
access. But i already have set of complex formulaes in excel. Now i want to
iteratively fetch the records from access, perform the calculations in excel
and store it back in access. Pointers pls....

I am able to successfully fetch the data from access and perform calculation
in excel and store the output when the recordset is less than 65536. But i
would like to iterate the same process for more records....

Is there a way/query to access only between n and m records.....
How do i get the record count ????