In some windows client versions of ORACLE (I think it is there in v8, not
sure about 9i or 10g) there was a utility called the ORACLE migration
wizard. This would take a MS Access database as input, read the
table,schema information and create a corresponding schema on the oracle
side. This included creating triggers to duplicate MS autonumber fields
and some other conversion tasks... It would then drop the local access
tables and convert them to Linked tables to the oracle database. In
theory all the MS forms, reports would continue to work...

This might be an option depending on what you want to do.


John Best - Project Manager (PMP)
Caterpillar Global IT
Distributed Factory & Procurement Systems Development
309-675-9950 (5-9950)
[Email address protected]



"v" <oracledba-ezmlmshield-x86095148.[Email address protected]
06/02/2005 02:07 AM


To
To
"LazyDBA Discussion" <[Email address protected]
cc




Subject
Migrationg MDB file to oracle




Caterpillar: Confidential Green Retain Until: 07/02/2005 Retention
Category: G90 - General Matters/Administration



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