If it is just one table, then you can simply export the file (File >
Export) from MS Access to Oracle. If it is a more complex db (ie.
Multiple tables and relationships) than you can you the Oracle Migration
Workbench which has the functionality that John Best described in his
message.

Regards,
Dan

-----Original Message-----
From: v [mailto:oracledba-ezmlmshield-x86095148.[Email address protected]

Sent: Thursday, June 02, 2005 3:08 AM
To: LazyDBA Discussion
Subject: Migrationg MDB file to oracle



Hello,

a bit hasty task i have an excel file and what i want is to import this
file in a form of table in oracle ..

so what i did is made an mdb file out of the excel file and now i want a
way to make an oracle table with all the entries reading from the mdb
file.

is there any way to do it..

Please advise

Vijay Shah
Software Developer


--------------------------
This message contains confidential information and is intended only for
the individual named. If you are not the named addressee you should not
disseminate, distribute or copy this email. Please notify the sender
immediately by email if you have received this email by mistake and
delete this email from your system.

--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page