[AccessD] OT - Oracle Discoverer OLE and Access

Charlotte Foust cfoust at infostatsystems.com
Wed Feb 9 13:31:45 CST 2005


Drop the link and create a new one.  That's the simplest method.

Charlotte Foust


-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com] 
Sent: Wednesday, February 09, 2005 9:22 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] OT - Oracle Discoverer OLE and Access


It does sound confusing.  I'm overwriting the csv file with the new one
- but the link I've setup from Access to the csv remains intact - that's
what I meant by updating.
 
I want to export from Discoverer to the csv that is linked to my Access
db.
 
It's a roundabout way of doing things, I know.  Here are my issues -
could not use an ODBC connection directly to Oracle for several reasons
but the most compelling was the inability to view any CLOB fields.  I
can create reports in Discoverer but the CLOB fields I need are rows in
Oracle but need to be columns for my end report - so I'm using Access to
do that.  Plus I need to add additional fields of data that are not
stored on Oracle, but are in Access (for the time being).  As clumsy as
it sounds, this seems to be my best solution.  I can get my coding to
run the Discoverer report, but I don't know what code to use to have the
report exported to the csv file.
 
Hope that all makes sense.
 
Terri Jarus
Vice President, Contract Services
jarus at amerinet-gpo.com
314-542-1902

>>> cfoust at infostatsystems.com 2/9/2005 10:44:44 AM >>>

I'm lost.  Are you trying to find code to export from Access or from
Oracle Discoverer?  And where would you be updating the csv file from?
Ordinarily, you overwrite csv files, not update them.

Charlotte Foust


-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com] 
Sent: Wednesday, February 09, 2005 5:02 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] OT - Oracle Discoverer OLE and Access


I am attempting to get information from a Discoverer report exported to
a CSV file and then pulled into Access - the data is complicated which
is why I'm using this process.

I have code setup in Access that opens/runs the applicable Discoverer
report but I don't know the commands to export via code to a csv file.

I have a link from Access to the csv file - but need to update the csv
routinely.

Anyone have any documentation that shows the commands for Discoverer??

I have a document entitled "Oracle Discoverer OLE Automation Developer's
Guide", but it doesn't include any commands for exporting. 
I've also posted on the Oracle Metalink site, but thus far have no
responses.

Thanks for any help.  I appreciate it.

Terri Jarus
Vice President, Contract Services
jarus at amerinet-gpo.com
314-542-1902

------------------------------------------------------------------------
---
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return 
it to the sender, and erase any copies thereof.
Copyright 2005 Amerinet 1nc.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list