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