undefined function when importing access query into excel

  • Thread starter Thread starter Thomas Spellman
  • Start date Start date
T

Thomas Spellman

I have a query in access that uses a homegrown function to output a
season string column for each row based on its date ( Season:
getSeason([tblSiteVisit].[Date]) ) . When I try to import this query
into excel using "get external data" I get a "function is undefined"
error. What do I need to do to get this to work?

T
 
You're saying you've created a function in the Access database, and you're
trying to run it from Excel?

Unfortunately, you can't.
 

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

Access #Error & Excel Pivot 0
Undefined Function DATE 4
Undefined function "Date" in expression 3
Undefined Function error - Complex 3
Undefined function 3
Date expression in Query 4
Query IIF function 3
Undefined function 'concatenate' in expression 0

Back
Top