Terri Jarus
jarus at amerinet-gpo.com
Mon Feb 14 06:38:55 CST 2005
I don't think I'm communicating correctly - the csv file is not the issue. The issue I'm trying to resolve is communicating with Discoverer to perform the EXPORT - those are the commands I can't seem to find. What I did find, and what seems to work OK - is running from the command line, such as: C:\DevSuiteHome\bin\dis51usr.exe /connect USERNAME/Password at ConnectionName /open "U:\Suppliers\Oracle\Oracle Reports\Ext_Exp_Other.dis" /export CSV "U:\Suppliers\Oracle\Oracle Reports\Ext_Exp_other.csv" /batch I can call this from within Access and it works - just didn't seem to be the optimal solution. Terri Jarus Vice President, Contract Services jarus at amerinet-gpo.com 314-542-1902 >>> Gustav at cactus.dk 2/10/2005 12:14:10 PM >>> 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------------------------------------------------- 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.