On Mon, 30 Aug 1999, Jose Suarez wrote:
> Ari,
> 
> I am a college student here in Mexico. I have been surffing the net trying 
> to find a way to convert an Access 7.0 Database to Oracle for a school 
> project. I ran into your webpage and saw a message that someone else sent 
> you on a similar request.
> 
> My question is:
> 
> Is there a way to fully convert an Access database (forms, tables, queries 
> and reports) to Oracle? and if this is possible, how?
> 
> Thanks beforehand and regards,
> Roberto Lozada, Mexico City.
To: Jose Suarez 
Jose,

I have converted Access to Oracle before and can say yes, it is possible.

Queries: they mostly convert straight to Oracle. There are differences in
wildcards (Oracle uses % whereas Access uses *), and outer-joings.

Reports + Forms: You can keep your reports and forms in Access and use an
ODBC link to the Oracle tables. Otherwise, you have to redo them in Oracle
Developer 2000 from scratch.

Macros: You have to rewrite these from scratch in Oracle

Tables: Create them in Oracle, then link the table in Access and run an
APPEND query in Access.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

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

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