Save it as a csv and then format it as a CTL file. You can import it that
way, either as a replace or as an append.



-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x15027826.[Email address protected]
Sent: Thursday, June 02, 2005 10:04 AM
To: LazyDBA Discussion
Subject: RE: Migrationg MDB file to oracle


If memory serves my, you can get the excel file into Microsoft access. The
you can save or export the file to the database using an odbc driver.

-----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




--------
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