Transferring 4 tables from ACCESS2000 to Oracle 9i

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
 
J

Jeff Boyce

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Access 2000 read Oracle 9I tables? 2
To convert from Oracle Database to Access 5
Access using Oracle ODBC linked tables-Split for multi users/bldgs 1
link to oracle table list shown is incomplete 1
DSN-Less Connection to Oracle db 2
ASP - Connecting to Oracle 9i 1
Convert Tables - Access to Oracle 2
Uploading data from Oracle to MS Access 3

Top