Interested to Buy Any Domain ? << Click Here >> for more details...
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
- 5 Answers
- 16659 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 start your 10g xe server from command line?
How to write an inner join with the where clause in oracle?
What is the difference between 10g OEM and 11g OEM?
What are the uses of linked server and explain it in detail?
How to select some columns from a table in oracle?
How to see free space of each tablespace?
17. Display the order number and average item cost for each order.
How to export your connection information to a file?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to convert character types to numeric types?
How to empty your oracle recycle bin?
why can't we assign not null constraint as table level constraint
Oracle General 
