Re: Using SQL Loader to import data with carriage return

Hi,

        I have written a tool that can help you migrate data from Access to oracle. You won't have to first export to a text file and then to Oracle. Go to the "Free software" section at http://www.imranweb.com and download WinSQL professional. Besides other features, it is a great tool for data migration.

Imran.

Lisa Soong wrote:
>
> Hi all,
>
> I am a newbie to Oracle and I am trying to import data from an Access
> database into my Oracle database by first extracting the Access data
> into a flat fixed length file (text) and then using SQL Loader ver8.0 to
> load that flat file into my Oracle database. However some of the
> address fields in MSAccess has carriage returns and when I export that
> into a flat file, SQL loader assumes that it is a new record and
> everything from there onwards get messed up! Is there anyway I can get
> SQL Loader to ignore the carriage return and to just judge record length
> from positions as set in the SQL Loader control file?

-- 
===========================================
Imran Hussain
MCP, MCSD
imranh_at_imranweb.com
http://www.imranweb.com
===========================================