Any other ways to use excel fcts in Access SQL

[vjp2.at]

If I was willing to write a VBA function?

THe inputs are arrays, though.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[Bob Barrows]

If I was willing to write a VBA function?

THe inputs are arrays, though.

No. Forget about it. You will need to write your own custom functions that
do the same things the Excel functions do and store them in an Access
module. Excel modules just aren't visible to Jet SQL, or any other brand of
SQL, for that matter.

Another thing to keep in mind is that if you use ADO to execute your
queries, even if you execute the code in an Access module, the queries
referencing the custom functions will fail. DAO does not have the same
drawback.