I need to load data from an Access database to Oracle database.
I have a table with several fields, one of them is a memo field (Access) and I have to load it into a CLOB field (Oracle).
I use a CTL where I delimited every field with the '$' character.
I export the Access table to a text file.
I think that it gives me the ORA-01722 because I have chr(13) and chr(10) in the memo field, so there are some records in more than one line.It is also very important to me to load also the chr(10) and chr(13) because there is an interface to show it.
How can I resolve it??
Thank you very much.