[AccessD] OT - Oracle Discoverer OLE and Access

Hi John and Terri

In the normal sense they cannot be updated.
However, as long as the file is not opened by, say, a query in Access,
they can be regenerated (by VBA code or TransferText) and simply copied
over the old file. When opened next time by Access, the revised data
will be present - even if they are linked.

Not very fancy but it works.

/gustav

>>> jwcolby at colbyconsulting.com 10-02-2005 18:57:41 >>>
Yes, but CSV files are just comma delimited files and cannot be
updated
(which the email said was needed).

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/ 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence
Sent: Thursday, February 10, 2005 4:08 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] OT - Oracle Discoverer OLE and Access


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