It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
- 5 Answers
- 17232 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bikash khuntia
Import both types whether .xls or .txt into Oracle table by
sql loaded with Control file. We can load large no. of
records in few seconds.
Thanks
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / venkat
Create a DSN for ORACLE DRIVER AS TEST THROUGH ODBC
OPEN THE EXCEL FILE IN ACCESS FILE
EXPORT INTO THE TABLE THROUGH DSN(oDBC)
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / amit
Thanks Kiran & Hima and sory for let reply.
Actully I want to Import data from SQL server to
Oracle. in that database some files are in .jpg format
means image format is there any query to import data from
SQL server to Oracle.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / hima bindu
Hi
If u want to import the data which is in .xls file to
oracle data base then first create temporary table in
database then write insert statements in excel file using
functions then execute that scripts into toad. Then the
data in excel sheet is imported to data base.
| Is This Answer Correct ? | 7 Yes | 12 No |
Answer / kiran kumar
open the TOAD and run the QUERY by using the SELECT
statement. after that click the right button and select the
SAVE AS button, in that select .xls Radio button and enter
the file name automatically data store in that file
| Is This Answer Correct ? | 4 Yes | 29 No |
Difference between inner join vs where ?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
State some uses of redo log files?
What to do if dba lost the system password?
Explain the use of grant option in exp command.
What are the set operators union, union all, minus & intersect meant to do?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Describe the different type of Integrity Constraints supported by ORACLE ?
what is difference between where clause and having clause?
How to convert csv to table in oracle?
How different is ms access and oracle?
Oracle General 
