Interested to Buy Any Domain ? << Click Here >> for more details...
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
- 5 Answers
- 16916 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 |
Can group functions be mixed with non-group selection fields?
what r routers?
What is dynamic proxy?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Can a property clause itself be based on a property clause ?
How to drop a stored function?
What is a Tablespace?
Can the default values be assigned to actual parameters?
How to find out what oracle odbc drivers are installed?
What is where clause in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How do I call oracle stored procedures that take no parameters?
Oracle General 
