Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: .dbf to Oracle
We've done a few different things in the past.
1. If the fields in the .dbf match your Oracle table exactly, create a
delimited text file and then SQL*Load it.
2. If you have to do some re-mapping, use something like Delphi to read a
.dbf record, re-format it and write it to the Oracle table.
3. If you want to do the mapping at the Oracle end create a table in Oracle
that matches the .dbf, create a delimited file and SQL*Load the data, then
use Forms or just PL/SQL to re-map the data into the real Oracle table.
HTH
--
Tim Shute
Software Engineering Manager
NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH
Internet: www.nisoft.co.uk
River <wychan_at_vol.net> wrote in message news:37330B80.A324181B_at_vol.net...
> Hello,
>
> How to convert the data in a .dbf file to Oracle table?
>
> Thanks for any advice,
> River
> wychan_at_vol.net
>
Received on Wed May 12 1999 - 03:27:27 CDT
![]() |
![]() |