how to use ACCESS database 1

[oracler]

Hello. I am a newer with Oracle. Could anybody teach me how to use or convert ACCESS database in Oracle 8.Thanks

 

[Guest_imported]

When I used it, I used it with Oracle 8i (8.1.6).
There is a utility called Oracle Migration Assistant.
It is solely intended to migrate data from Access to Oracle
and it is self_explanatory.
sokeh

 

[Guest_imported]

You can also try this:
To move data from Access to Oracle, you can do one of two things:

1) Make a link to an existing Oracle table from within Access. Go to
"File", "Get External Data", "Link Tables". Then use an ODBC driver
(Oracle has a 32-bit or you can use InterSolv's) to link to your database.
If you have not set up an ODBC driver before, you do this in "Control
Panel" and then click on the "ODBC" icon, depending on your OS. Now that the Oracle table is
linked, you can do all Access functions on it (Append, SELECT, Reports,
Forms, etc.)

2) Export from Access to an ASCII delimited file. At this point, use
Oracle's SQL*Loader to load the data into Oracle.

 

[oracler]

Hey, Sokeh. Thanks a lot for your responses.