D
Debris
Hello,
I have an Excel worksheet that takes basically one piece of data, runs a
bunch of calculations, and produces a result. It uses some fancy formulas
(SUMPRODUCT), lookup tables, and even boolean algebra that I'm not too eager
to try and replicate in an Access query. (In other words, while the
worksheet is complex, it basically has one input and one output.)
Now, I want to run these calculations on a series of datapoints/records.
Can I create a query to pass the one datapoint to the Excel worksheet, let
the worksheet perform its calculations, and pass the result back to the
Access query? If so, can someone point in the right direction to some
resources how to do this?
(While the MS Office Help is usually a lot of help, all I'm getting is
answers on import/export, but I'm not looking to import data from Excel, nor
do I necessarily want to export it to Excel, either.)
Thanks, D
I have an Excel worksheet that takes basically one piece of data, runs a
bunch of calculations, and produces a result. It uses some fancy formulas
(SUMPRODUCT), lookup tables, and even boolean algebra that I'm not too eager
to try and replicate in an Access query. (In other words, while the
worksheet is complex, it basically has one input and one output.)
Now, I want to run these calculations on a series of datapoints/records.
Can I create a query to pass the one datapoint to the Excel worksheet, let
the worksheet perform its calculations, and pass the result back to the
Access query? If so, can someone point in the right direction to some
resources how to do this?
(While the MS Office Help is usually a lot of help, all I'm getting is
answers on import/export, but I'm not looking to import data from Excel, nor
do I necessarily want to export it to Excel, either.)
Thanks, D