Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
importing excel data into oracle tables
- Thread starter ovishvesh
- Start date
- Thread starter
- #3
By a direct insert he means taking the data in the spreadsheet and building many INSERT INTO statements to add the data to the database.
When he said "export" the data, he simply meant save it as another file type, other than Excel. Save the excel spreadsheet as a delimted text file. I suggest using a pipe symbol (|) as a delimter because you are very unlikely to have pipes in the data itself.
Once you have the pipe delimted text file, use SQL*Loader to load the data into Oracle.
The SQL*Loader manual page can be found here:
You will need to sign up for Oracle Technet (it is free) to access that document.
When he said "export" the data, he simply meant save it as another file type, other than Excel. Save the excel spreadsheet as a delimted text file. I suggest using a pipe symbol (|) as a delimter because you are very unlikely to have pipes in the data itself.
Once you have the pipe delimted text file, use SQL*Loader to load the data into Oracle.
The SQL*Loader manual page can be found here:
You will need to sign up for Oracle Technet (it is free) to access that document.
- Status
Similar threads
- Locked
- Question