Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
Can you use VBA to query an Access database without importing data | Excel Programming | |||
Importing access query | Excel Discussion (Misc queries) | |||
Importing Access Query | Excel Discussion (Misc queries) | |||
Importing a table from Access query | Excel Discussion (Misc queries) |