can I use an array formula to query a source data table?

T

TAD from DBL

Is it possible to use an array formula to query an excel source data table?

How would the criteria work?
 
J

Joel

I'm not sure but instead you can open the access opbject to get the data.

Set obj = CreateObject("Access.application")
obj.Visible = True
Set myDB = obj.Open(Filename:="c:\temp\myDB.mdb")
 

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

Excel Wildcard in Excel array formula 0
Array Formula In IF Function 0
Can I use a UDF in an array formula? 2
vba array logic 3
problem with array formula 5
Excel-Query-Access Question 3
Array computation in vba 1
UDF in Excel 2007 for Filter or Query 2

Top