RE: Import from FoxPro to Oracle

Well at least this means that it can be done. But aren't there any tools like "Oracle Migration Work bench" or the "Oracle Migration Assistant for Access" . The odbc of WIn2000 doesn't support .dbf files, it goes to .DBC for visual foxpro. So is there any possibility of simplifying the import procedure?

-----Original Message-----
Sent: Friday, November 15, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L

> Hussain Ahmed Qadri wrote:
>
> Hi ALL,
>
> Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7.
> If yes how.
>
> TIA
>
> Hussain

I have done something of the kind in the past by writing a program taking a .dbf file on its standard input and writing a control file including the data to its standard output, which was then awfully easy to load. I no longer have the program but it took about half a day to write, including the search on the internet to find out what the structure of a .dbf file is, because I had no idea about it. The only tricky thing I remember is that I wrote it to run on both Solaris and Tru64 and in one case (Solaris, I think) some bytes had to be swapped ('man swab').

--
HTH,

Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hussain Ahmed Qadri
  INET: hussain_at_skm.org.pk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).