Home » Developer & Programmer » Forms » Paradox File (.DB) to Oracle
Paradox File (.DB) to Oracle [message #394263] Thu, 26 March 2009 05:50 Go to next message
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
Re: Paradox File (.DB) to Oracle [message #394354 is a reply to message #394263] Thu, 26 March 2009 10:17 Go to previous messageGo to next message
Littlefoot
Messages: 21821
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.
Re: Paradox File (.DB) to Oracle [message #396462 is a reply to message #394354] Mon, 06 April 2009 18:56 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9100
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

Re: Paradox File (.DB) to Oracle [message #396532 is a reply to message #396462] Tue, 07 April 2009 02:30 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
first search forum connect to access, connect to ms sql server 2005

second
http://www.orafaq.com/forum/m/396240/124740/?srch=connect+access#msg_396240
and
http://www.orafaq.com/forum/m/394989/124740/?srch=connect+access#msg_394989


Littlefoot dont right. You may connect to paradox file.
Re: Paradox File (.DB) to Oracle [message #396562 is a reply to message #396532] Tue, 07 April 2009 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
/forum/fa/1600/0/

I've never said that it can't be done, but that I don't know whether it is possible or not. ODBC? Sure, why not?!
Re: Paradox File (.DB) to Oracle [message #396565 is a reply to message #396562] Tue, 07 April 2009 04:02 Go to previous message
ora_baby
Messages: 89
Registered: May 2008
Member
Rolling Eyes
Previous Topic: issue with vietnames languages
Next Topic: Looping is not working
Goto Forum:
  


Current Time: Sat Nov 09 16:21:06 CST 2024