Conver the same in to CSV Format and create the control file and do the insert operation to the table through sqlldr.

Bala

-----Original Message-----
From: v [mailto:oracledba-ezmlmshield-x86095148.[Email address protected]
Sent: Thursday, June 02, 2005 12:38 PM
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




Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page