Discussion Locked

Import Data into Oracle

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to import data in oracle from a text file or excel or access tables, so kindly inform me for this purpose what I will have to do? What will be pre-requisite to perform this task. Further if some article or book is available regarding to this then also qoute about that article or book please. Waiting for your early response on following my email address.
nadeem1@asia.com

7 replies

by epepke

There are an infinite number of ways of doing this. Here is the way that I prefer for quick and dirty imports:

1) Write a Perl script to read the data and produce SQL INSERT statements. Perl is free, and you can download it from www.perl.com.
2) Paste the SQL INSERT statements into SQL PLUS or something like SQL Navigator. Run them there.

This may not be particularly fancy or elegant, but it gets the job done very quickly.

by gparreira

Hi, nadeem1,

Maybe the best way is to create a ODBC connection with your oracle database and use it to access your tables and insert there the contents of your text, excel or access files. In what plataform are you running Oracle? Does you know how to implement this connection? Please let me know if you need more support concerning this...

Bye,
Gilberto

This discussion is closed to new replies.