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: 68769
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 02 13:42:35 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.