Home » SQL & PL/SQL » SQL & PL/SQL » import data in excel sheet to oracle
import data in excel sheet to oracle [message #857] Fri, 08 March 2002 20:02 Go to next message
Biswaranjan
Messages: 3
Registered: March 2002
Junior Member
I want to import data in excel sheet to oracle database.can any buddy help me out.
regards
biswaranjan
Re: import data in excel sheet to oracle [message #859 is a reply to message #857] Sat, 09 March 2002 05:22 Go to previous message
Hassan Ayub
Messages: 17
Registered: November 2001
Junior Member
Hi there,

Yes you can. Follow the following steps:
1. Open the excel sheet in Access 97 and save it as mdb file.
2. Use the Access Migration Assistant In Oracle 8 and simply convert the Access database to Oracle, the Assistant is self explantory and will guide you step by step.

If you still need any help, feel free to contact me at my email address:

hassan_ayub@yahoo.com

good luck!!

Hassan
Previous Topic: Data dictionary into a temp table
Next Topic: Please, I need advise
Goto Forum:
  


Current Time: Thu Mar 28 23:54:18 CDT 2024