It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between functional dependecy and multilevel dependency?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to unlock the sample user account in oracle?
What are the different types of failures that occur in Oracle database?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Does oracle charge for java?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is an oracle cursor variable?
Explain database link?
What is the difference between a hot backup and a cold backup in oracle?
What is the data type of dual table?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are data pump export and import modes?
How to use "if" statements on multiple conditions?