Home » RDBMS Server » Server Utilities » HELP !! how to import a CSV file to Oracle 8i
HELP !! how to import a CSV file to Oracle 8i [message #69262] Fri, 30 November 2001 04:06 Go to next message
Heinz Prochaska
Messages: 2
Registered: October 2001
Junior Member
Can anybody tell me how to import a csv file into an Oracle 8i Table without having Oracle management server installed.
Many thanks for help

----------------------------------------------------------------------
Re: HELP !! how to import a CSV file to Oracle 8i [message #69265 is a reply to message #69262] Fri, 30 November 2001 05:04 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use sqlloader utility.

----------------------------------------------------------------------
Re: HELP !! how to import a CSV file to Oracle 8i [message #69275 is a reply to message #69262] Sun, 02 December 2001 16:16 Go to previous message
Prasanna Sukhi
Messages: 2
Registered: December 2001
Junior Member
The easiest way to do it is with MS-Access. Link the oracle table using ODBC. Then create a balnk table with the structure of the CSV file. with an INSERT INTO query populate the oracle table with the CSV table.

----------------------------------------------------------------------
Previous Topic: Re: Can't startup the database - new user
Next Topic: Re: How to load from excel into database table?
Goto Forum:
  


Current Time: Thu Mar 28 06:08:08 CDT 2024