I have a question. Is it possible to run Access queries by using a macro and using the output table in Impromptu report. What would be the macro to run access queries.
Thanks in advance.
Swathi.
Swathi,
If you create a catalogue in Impromptu against your access database, then so long as you open that catalogue when running your macro (e.g. "objImpApp.OpenCatalog "x:\catalogues\access.cat","Creator",,,,1," impromptu reports called thereafter will work ok.
You should find ODBC drivers for Access as part of your windows install ('fraid I can't help with Unix).
HTH,
lex
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.