> I recently browsed through ur webpage to get some tricks on how to export data
> from my database in Access to Oracle..But unfortunately I couldn't find an
> answer..
> If u can help me it would be great..My database is pretty large  about 1.5 MB..
> And I have already defined my tables in Oracle 7.3. The only problem is
> transferring records from my Access table to Oracle table..Help would be
> greatly appreciated.

There are two ways to do this:
1) Export the Access table into a tab-delimited ASCII file. Then use
   SQL*Loader to load the data into your existing Oracle tables. You will have
   to set up the SQL*Loader control files, which is documented in the
   "Oracle Utilities Guide" book, among other 3rd-party books.
2) Set up an ODBC connection between Access and Oracle. Then, you can cut and
   paste or run an update query in Access.

Best of luck!


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page Kaplan's Home Page