A
Anand
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 ????
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 ????