Re: Transfering data

Alter the code that generated the script to find ' in your strings and replace them with '' (two single quotes, not one double).

'L''oreal' and 'TEACHER''S HIGH' will workin INSERTs.

You say you're transferring from "dbf". Do you mean dBase/FoxPro .dbf? If so, an alternative would be to use the upsize wizard in Visual FoxPro or Access.

Best!

Randall

<btomljan_at_NOvipSPAM.hr> wrote in message news:MPG.157e06a2e8a6fdfe989680_at_news.hinet.hr...
> I'm transferring data from dbf to Oracle and I'm stuck with few fields
> containing ' in them - such as "L'oreal" or "TEACHER'S HIGH...)
> I have created script with INSERT INTO ... and of course the ' is
> treated as the end of string and for that record I got an error 'couse
> after that field everything is mixed up.
> Is there a way I can transfer data without removing the ' from string?
> Any help would be appreciated.
>
> Boris
> Pls remove NO SPAM if answering by e-mail
>
>
Received on Tue May 29 2001 - 21:20:36 CEST