Re: Fox pro 2 Oracle

Well, that sure sounds easy, but I don't know about stuff like primary keys (where Oracle is a bit more stringent than VFP) and date formats and datetime formats and memo fields and logical fields and code pages...

Because as soon as APPEND runs into an Oracle error, it just sort of stops appending. What then ?

On Sun, 4 Mar 2001 10:16:18 +0100, "Jim Davis" <jimdavis_at_iprolink.ch> wrote:

>Create a VFP view (if this is VFP) for the Oracle data, in the same format
>as the data you want to import. Make sure to turn on the appropriate update
>options in the view. Open that view, and APPEND into it.
>
>Jim Davis
>Informatique Ressources Humaines
>
>
>
>"Tristan" <moonshine_at_apex.net.au> wrote in message
>news:983444934.868085_at_draal.apex.net.au...
>> Is there a simple way to copy in foxpro data into oracle tables? At the
>> moment I am copying out the foxpro data to a simple file, then using the
>> sqlldr utility.
>>
>> Thanks,
>>
>> Tristan
>>
>>
>
>

EMail: knijff_at_bigfoot.com Received on Sun Mar 04 2001 - 09:33:24 CST