Invalid function importing data query from Access
 

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
workbook.
Thanks,
Jim

Invalid function importing data query from Access
 

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.
--
HTH...

Jim Thomlinson


"Capt James Cook" wrote:

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
workbook.
Thanks,
Jim