Transferring 4 tables from ACCESS2000 to Oracle 9i

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have 4 tables in ACCESS 2000.
I want those 4 tables, and all their correct field types and definitions to
be in Oracle 9i. How would i do this?
Can i directly import into Oracle, or can i save the SQL script for creating
the tables from ACCESS, and run it into Oracle??

Thanks,
Jason
 
Jason

If you were working with another product, you would use that product's data
transfer features. If you want Oracle to "adopt" some tables from Access,
what data transfer features do you have in Oracle?

I'm not familiar with a way Access can "force" its way into Oracle (but hey!
there's a lot I don't know!).

By the way, there are no guarantees that Oracle and Access have 100% data
type compatibility.
 
Back
Top