Re: Convert comma-seperated file to oracle DB
From: Chris Fischer <cfischer_at_nando.net>
Date: 1996/03/18
Message-ID: <4ikm17$2l9_at_castle.nando.net>#1/1
Date: 1996/03/18
Message-ID: <4ikm17$2l9_at_castle.nando.net>#1/1
"D.S. McNicholl" <eqr6mcnichd_at_grid.unl.ac.uk> wrote:
>Is there a way to convert a comma seperated file into an oracle
>databse ?
yes. Use SQL*Loader on the database server
>Is it possible to convert an access database into an oracle
>database ?
yes. Use ODBC in Access to attach the tables to the Access database. Then you can use an Append query to append rows from the access table to the oracle table that you've created to hold the data. Hope this points you in the right direction.
+------------------------------------------------------------+ | Chris Fischer cfischer_at_nando.net | | Sr. Systems Analyst Work: (919)676-0062 | | Toys "R" Us | +------------------------------------------------------------+Received on Mon Mar 18 1996 - 00:00:00 CET