access and excel functions

K

k2sarah

i have an acces table consisting of ~3000 rows. i would like to calculate a
rolling standard deviation/kurtosis/skew and a slew of other excel functions
over 20 days. i am aware that i am able to call excel functions in ms access,
but as there will be 2980 calls for each function, it is extremely slow. can
you recommend a better approach.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

KURT and SKEW functions 8
pull data from Access into Excel VBA function, return answer to Excel 1
Skew and other statistics in Access 2
Automation: Invoking Excel Financial Functions Without InstantiatingExcel? 4
Appending Excel Files to Access 1
Excel Functions 1
using excel functions in access 1
Import SQL Server User-Defined Functions into Access 2002 6

Top