Re: How to Convert Oracle dbf to dBase dbf
Date: 1997/04/04
Message-ID: <01bc40c3$b8dfb400$b103018e_at_pc4496>#1/1
I don't understand what an Oracle .dbf file is.
But if you want to convert Oracle tables in .dbf files or in Access tables,
the easiest way is to connect to Oracle with Visual dBase, FoxPro or Access
via ODBC or via IDAPI. If you do it, it's very simple to create the
corresponding files.
With Access, you have just to import Oracle tables (with the menu File ->
Get External in Version 7, something similar in version 2). With Visual
dBase, you must connect to the Oracle database with the "OPEN DATABASE"
command and you can copy the Oracle table in dBase or Paradox format. You
can also create .dbf files with Access. With Visual FoxPro, I suppose you
can find something similar.
If you can't connect to Oracle database with Access or dBase, you can use a
different method. You can export data from Oracle with SQL*Plus in a text
file and import the data in dBase, FoxPro or Access.
You can write a script like this :
SET PAGESIZE 0
SET LINESIZE 1000 (depending of the longest row)
SET FEEDBACK OFF
SPOOL xxx.txt (filename)
SELECT * FROM <Table>;
SPOOL OFF
You obtain so a file with fixed-length record. The easiest way to convert
such a file to a .dbf file is to use Excel, if it's possible.
You can also create a SDF file. It's more difficult in SQL*Plus but easier
to import. You must write a SQL command like this (for EMP table, by
example) :
SELECT to_char(empno) || ',"' || ename || '","' || job || '",'
|| mgr || ',"' || to_char(hiredate, 'mm/dd/yyyy') || '",'
|| to_char(sal) ||','|| to_char(comm) ||','|| to_char(deptno)
FROM emp
Aibek Musaev <abbey_at_cc.gatech.edu> wrote in article
<01bc39b2$6b023540$30403d80_at_r64h48.res.gatech.edu>...
> I have Oracle .dbf files. Is there any converter of Oracle .dbf files to
> other databases files, like dBase (dbf), FoxPro (dbf), MS Access
(mdb)?
>
> Thanks a lot.
>
> --
> ______________________
> Aibek M. Musaev
> 324396 GA Tech Station
> Atlanta, Georgia 30332
> e-mail:
> abbey_at_cc.gatech.edu
> phone: (404)206-4515
> url:
> http://aibek.gt.ed.net
>
> ******************
> Quote of the week:
>
> The Airplane Law:
> When the plane you are on is late, the plane you
> want to transfer to is on time.
>
>
Received on Fri Apr 04 1997 - 00:00:00 CEST