Re: Importing

From: hi <1_at_23.com>
Date: 2000/05/12
Message-ID: <1ZYS4.15184$Ic5.5056471@news3.mia>#1/1

I have a solution. I am in the middle of do this. I created 2 clipper programs.

first program that dumps the structure to an ascii file, and the other that dumps the data to an ascii file(ie address.txt).

take the ascii structure file and wrap 'create table address' command around it (execute sql script)

create a 'ctl' file with the same ascii structure file.

sample 'address.ctl' file

LOAD DATA
INFILE *
APPEND INTO TABLE address
fields terminated by "," optionally enclosed by '"' TRAILING NULLCOLS

(        name,
         addr1 ,
         addr2 ,
         birthday               DATE "YYYYMMDD",
         ssn

)
<end of address.ctl' file>

now run sqlLoader:

sqlldr userid=username/password control=address.ctl log=addressrslt.log data=address.txt

'addressrslt.log' - log file of the results 'address.txt' - ascii input file from DBF

maybe this will help

Paul Kolbohm <paul.kolbohm_at_mallon.demon.co.uk> wrote in message news:957945320.19176.0.nnrp-14.9e98496d_at_news.demon.co.uk...
> I am looking everywhere for information on how to copy files from FoxPro
> clipper data base to Oracle 8.0.5 direct
>
> please e-mail directly to paul.kolbohm_at_mallon.demon.co.uk
>
>
>
Received on Fri May 12 2000 - 00:00:00 CDT