Interested to Buy Any Domain ? << Click Here >> for more details...
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
- 5 Answers
- 17077 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 |
How to convert a string to a date in oracle database?
What is columnar storage what is the advantage?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What is different types of joins?
How to create a new tablespace in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
1.display list of all users from ur data base.what is the query?
Explain the use of online redo log files in oracle.
What is RULE-based approach to optimization ?
Where is the export dump file located?
How to pass parameters to procedures?
What is data block in Oracle?
Oracle General 
