[AccessD] OT - Oracle Discoverer OLE and Access

Jim Lawrence accessd at shaw.ca
Thu Feb 10 03:07:55 CST 2005


Hi Terri:

CSV files are basic spreadsheet data. It can be read by Excel and Access.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Terri Jarus
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




More information about the AccessD mailing list