Home » RDBMS Server » Server Utilities » Importing from Excel file into Oracle DB table (Oracle 10g, Xp)
Importing from Excel file into Oracle DB table [message #328954] Mon, 23 June 2008 09:15 Go to next message
suneelvarma_27
Messages: 28
Registered: April 2008
Junior Member
i have a excel file which consists of 60,000 records.
i want to import the records from this file into Oracle table using SQLLDR. Can u pls tell how can i do this?
how can i convert from excel file into csv?
Thanks in advance...

[Updated on: Mon, 23 June 2008 09:17]

Report message to a moderator

Re: Importing from Excel file into Oracle DB table [message #328962 is a reply to message #328954] Mon, 23 June 2008 10:10 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can u pls tell how can i do this?

First save your file in CSV file then read Database Utilities, part II SQL*Loader.

Quote:
how can i convert from excel file into csv?

File/Save As.../File type: CSV

Regards
Michel
Previous Topic: Field concatenation during load using SQL*Loader
Next Topic: schema export/import
Goto Forum:
  


Current Time: Fri Dec 09 11:35:14 CST 2016

Total time taken to generate the page: 0.08666 seconds