Re: Importing Paradox or dBase tables ???

In <3ghgrs$gft_at_indy-backup.indy.net> bstanek_at_indy.net (Brian Stanek) writes:

>
>Mubashir Cheema (cheema_at_earth.sparco.com) wrote:
>
>: I was just reading the help pages on Oracle Workgroup Server for NT,
>: and noticed that the "Import" functions are limited to files exported
>: to files exported using the Oracle export utility.
 

>: How do I import a simple, comma delimited, ascii table or a Paradox
 or
>: a dBase table ?
 

>: Any help would be appreciated.
 

>: Thanks.
 

>: Mubashir Cheema
>
>Use SQL*Loader. It will allow you to create a control file that will
>read comma delimited files. I have done this using Paradox files
>and it is very simple.
>
>Brian Stanek
>Profound Consulting
>

Another option is to import the table into MS Access, then export it to Oracle via ODBC. I used this option last week and it worked very nicely. Just make sure that your column names are upper case or they will be surrounded by " in Oracle, i.e. city will be "city".

-- 
--------------------------------------------------------------------
Doug Hackney                                  hackneyd_at_ix.netcom.com
--------------------------------------------------------------------