Home > IT Answers > Development > ORACLE
Abcd123411
0 pts.
 ORACLE
Development, Oracle
HOW CAN I MOVE DATA FROM EXCELL SHEET INTO ORACLE DATABASE TABLE

Software/Hardware used:
ASKED: October 10, 2005  8:38 AM
UPDATED: October 12, 2005  3:48 AM
RELATED QUESTIONS
Answer Wiki:
You could save the file in Excel as a .CSV file. Then use Oracle SQL Loader utility to import it into Oracle. Another way could be to use MS Access as the exporter from Excel and Importer to Oracle. Link the Excel table into Access. Use ODBC to link the Oracle table. Then make an append query to append the Excel data into the Oracle table. In Oracle, the table must be created and have a primary key.
Last Wiki Answer Submitted:  October 10, 2005  9:12 am  by  Randym   1,740 pts.
All Answer Wiki Contributors:  Randym   1,740 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

hi,

you can use the mecanism of external tables, you read this table as normal tables.

Roldfr
 0 pts.