Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbf --> Oracle Tables
Hi,
If you have Visual FoxPro, you can:
1. create temporary foxpro database
2. Add all tables into it, if names of tables have some skeleton, you can do it
in a loop.
3. Use Upsizing Wizard (with this utility ussually you have nothing to do more)
Cheers,
gg
John Koo wrote:
> Rex wrote:
>
> > Hi,
> >
> > I must load Oracle Tables from dbf files, and I have little program for
> > that. I have approx. 250 files in dbf format and the same Oracle tables. For
> > each table I must choose one dbf and one table which will load manualy. It
> > is about 250 times again.
> >
> > Can I do it from Oracle Loader ( I suppose yes)?
> > What is the control file for loader?
> > Can anybody help me to do it.
> >
> > --
> > Please remove nospam from my address to reply.
> > nebacar_at_eunet.yu
>
> You might :
> transfer all dBASE *.dbf files to text format ( I'm sure this is a easy thing
> to do!) and
> then load it into the Oracle using SQL loader,
>
> or import the *.dbf files into Microsoft Access and then import into Oracle
> using the
> Access Migration utility;
>
> John K.
Received on Fri Jan 22 1999 - 05:49:24 CST