Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to revoke create session privilege from a user in oracle?

960


What are oracle functions?

974


What are the different types of trigger and explain its various uses and functions?

1008


Please explain oracle data types with examples?

990


What is instant client oracle?

972


How to call a stored function with parameters?

969


What is max rowid in oracle?

964


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3273


How to establish administrator authentication to the server?

982


20. Using a set operator, display the client number of all clients who have never placed an order.

2145


Explain mutating triggers.

973


What is recovery manager(rman) backup in Oracle?

1125


What are the types of trigger in oracle?

914


What is an oracle and why it is used?

1077


How many categories of data types?

937