Any other ways to use excel fcts in Access SQL


V

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]
 
Ad

Advertisements

B

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.
 

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

5.3GB csv 6
del * from x where zip < 14500 3
Squirt query result into new table 7
Excel fcts in Access 1
Call ext db from/in 2
most frquent substring 3
varchar(1200) sep by ; 6
NAB + NCD -> NABCD 2

Top