RE: Import from FoxPro to Oracle

Tools like Powerbuilder/ Access can be used to import dbf files to Oracle tables.  

HTH
Sumathy Panicker  

-----Original Message-----
Sent: Friday, November 15, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L

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-----
<mailto:sfaroult_at_oriole.com> ]
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
<http://www.orafaq.com>  
-- 
Author: Stephane Faroult 
  INET: sfaroult_at_oriole.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<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: Panicker, Thankam S.
  INET: tspanicker_at_cooperstandard.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).