Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: .dbf to Oracle
> River wrote:
> How to convert the data in a .dbf file to Oracle table?
The best way I can think of is to write a program that does 2 things:
- It reads the header of the .dbf file and generates a SQL*Loader
control file
- It reads the rest of the .dbf file and generates a matching SQL*Loader
data file.
Then run SQL*Loader to load the data into the database.
The fileformat for a .dbf file is well-known.
--
Erwin Dondorp
<http://www.wxs.nl/~erwindon>
Received on Sat May 08 1999 - 20:01:00 CDT
![]() |
![]() |