Re: Oracle Browser 2.0 to Excel (Win95)
From: Mark Walter <mwalter_at_afit.af.mil>
Date: 1996/08/22
Message-ID: <4viech$ao1_at_blackbird.afit.af.mil>#1/1
Date: 1996/08/22
Message-ID: <4viech$ao1_at_blackbird.afit.af.mil>#1/1
Scott Morin <scottm_at_delorme.com> wrote:
>When doing a paste special link to Excel from
>and Oracle Browser (Edit/Copy) the all Excel
>cells are set to #N/A at which point they would
>normally format accordingly as occurs in NT.
>Any fix? If not this makes the paste link useless.
Under the Browser Edit Menu, select Preferences. Select the Preferences for: Query. On the right side of the pop-up menu will be two radio boxes under the Retrieve Data heading. Change the option from 'As Needed' to 'All at Once' and re-execute your query.
Once you re-execute the query and cut / paste the results to Excel, you wil no longer have the #N/As. Received on Thu Aug 22 1996 - 00:00:00 CEST