If you are using a recent version of Oracle (v9.0.1 or later) you can output
your Excel spreadsheet in CSV or SDF format. Then define an external table
to access it as any other Oracle table. I've done this successfully to
access system log files.
--
Cordially,
Edward F Eaglehouse < [Email address protected] <mailto:[Email address protected] >
Automated Solutions Corp <http://www.atmsol.com/>
Phone: 330-659-6335
_____
This document may contain confidential information or attorney work product
protected by attorney-client privilege. If you are not the intended
recipient, you must delete this and all copies of this document. Please
notify Automated Solutions Corp immediately of this misdirected
communication, by email at [Email address protected] <mailto:[Email address protected] , by
phone at 330-659-6335, or by fax at 330-659-6503.
-----Original Message-----
From: Prather Kristin Ms CN HQ USAREUR
[mailto:oracledba-ezmlmshield-x63933694.[Email address protected]
Sent: Thursday, June 02, 2005 04:07
To: LazyDBA Discussion
Subject: RE: Migrationg MDB file to oracle
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
--------
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