Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos Script Editor

Status
Not open for further replies.

Swathi37

Vendor
Dec 23, 2002
77
US
Hi,

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top