Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need help importing to LONG field
cris brady wrote:
>
> I have an Microsoft Access table that I need to import into Oracle. (7.3)
> I've created routines that create a control file for SQL Loader and
> exports the Access data into an text file.
>
> My problem is the table has one formatted text (memo) field that contains
> carriage returns/linefeeds in the field. So one record of the text file
> will look like this:
>
> field1 = "11111"
> field2 = "22222"
> field3 = "This is field three (cr/lf) this is line two (cr/lf) etc."
With multiline text, can't use sql*loader directly, unless you replace
the
line feed with space, say.
With 300 records you can simple write a query to upload access table to a ODBC-attached Oracle table. Slow but simple.
You can use some pipeline tools, like PowerBuilder DBPipeLine. What
they do
is just read a record and insert a record, but automatically.
Such requirement is straight forward, I am sure you can find a way. Received on Wed Apr 09 1997 - 00:00:00 CDT