Create a DSN for ORACLE DRIVER AS TEST THROUGH ODBC OPEN THE EXCEL FILE

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

Question Posted / venkat

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

Please Help Members By Posting Answers For Below Questions

Point the difference between translate and replace?

1094

What is max rowid in oracle?

1025

How to concatenate two text values in oracle?

1114

does the query needs a hint to access a materialized view?

1859

What are the advantages of oracle 12c?

1182

What are operators in oracle?

1057

What is Undo Management Advisor in Oracle?

1099

Differentiate between pre-select and pre-query?

1112

How to delete an existing row from a table in oracle?

1072

How to drop an index?

962

How to import one table back from a dump file?

1025

What privilege is needed for a user to insert rows to tables in another schema?

1015

What are the uses of linked server and explain it in detail?

1061

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

Difference between open_form and call_form in oracle.

1163