>>You can do as Edward explained, or...
>>
>>If you have access to the server Oracle is on, and you have sufficient rights on the server to execute Oracle's SQL-Loader utility, and your Oracle table structures (field order and Oracle column data types are equivalent) then:
>>You can create comma delimited text files with each table's data. You would have to do some conversion on your logical fields to make the data '0' or '1'. You would also have to handle memo fields as well. Upload these .txt files to the server and use SQLLDR to load the data into the Oracle tables.
>>
>>With each .txt file for SQLLDR, you can have a parameter file (.par) and a control file (.ctl). The control file is referenced by the .par file. The syntax on the server is: SQLLDR parfile=filename.par
>>
>>If you want to pursue this method, I can e-mail you examples of .par and .ctl files.
>
>
>I also used that method. Nut my main problem is ,
>
>1. if the data say text field contains " (quotes).
>
>2. and major thing is if the field contains 'enter key' which was used in
>memo fields mainly.
>
>I was not able to solve the enter key problem in memo fields. I put one quote extra i.e. "" if " is there.
>
>
>Please send the examples to me , so that I could solve that problem.
>
>Thanks for your keen interest .
>
>My e-mail address is spvedulla@hotmail.com
>or
>spvedula@rocketmail.com

The "Enter" key problem can be resolved in your memo fields with StrTran() function. StrTran(MemoFieldName,chr(10)," ") will eliminate the LineFeed and StrTran(MemoFieldName,chr(13)," ") will eliminate the CariageReturn. You will need to experiment with that cand of replace to see what you really need to do. Replacing Chr(13) with a space (or nothing -- "") may be all you need to do.

WHen I get back to work, I will e-mail you examples of the .PAR and .CTL files for SQL-Loader utility.