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