Invalid function importing data query from Access


Capt James Cook

We work primarily with Julian dates. I have an Access data query that
converts the Julian to Gregorian date using a function I built called
"Convert_Julian". I now need to create charts from the data but when I set
up the Data->Import External Data->New Database Query and point it to my
Access query, it fails with "Undefined function 'Convert_Julian' in
expression" message.
I need to rebuild these charts every day and I don't want to have to
manually copy & paste. I really need the data import to update my Excel



Jim Thomlinson

As a quick and dirty solution (I am not sure if there is going to be an easy
way around your function) could you do a make table query in Access to
populate a physical table? That should get you around the problem.

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