OraFAQ Forum: Forms » Paradox File (.DB) to Oracle

Home » Developer & Programmer » Forms » Paradox File (.DB) to Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Paradox File (.DB) to Oracle [message #394263]

Thu, 26 March 2009 05:50

waqar_rao
Messages: 1
Registered: March 2009

Junior Member

Hi All,

I have one paradox file called "A.DB" with atleast 20 columns.

Now i want to push those column's data into oracle10g DB.

What's the way to do that programatically, i mean on a push button trigger.

Regards,

Waqar

Report message to a moderator

Re: Paradox File (.DB) to Oracle [message #394354 is a reply to message #394263]

Thu, 26 March 2009 10:17

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know whether Oracle can (or can not) read Paradox files directly, but the most straightforward way to load any kind of data into an Oracle database is to create a CSV file (comma separated values) based on your source table (in this case it would be a Paradox table) and load it into Oracle using SQL*Loader.

Report message to a moderator

Re: Paradox File (.DB) to Oracle [message #396462 is a reply to message #394354]

Mon, 06 April 2009 18:56

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

You might also be able to use ODBC or the code in the link below, perhaps with some modification. Paradox, DBASE, and FoxPro are all XBASE and can read each other's files, so they must have the same or very similar formats, which you can look up.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:711825134415

[Updated on: Mon, 06 April 2009 18:57]

Report message to a moderator