Here's the a way to do that :

Importing to Access from Oracle


Open Access => Blank Database => Save it => File => Get External
Data => Import => Choose ODBC Database from the FILE OF TYPE => It
will ask for DSN NAME =>click on New => Oracle ODBC Drivers=>Type
the name i.e. Sunil =>type user name in User name box =>Ok => Select
the DSN Name i.e. Sunil=>ok=> type the password in Password box=>Ok
=>it will display all the tables of the selected user name=>select
table according to requirement=> ok=>it will import into the Access



Importing from Access to Oracle


Create a Blank table in Access frist if not exists=>File => Save
as/Export => select "TO AN EXTERNAL FILE OR DATABASE => select ODBC
Database from SAVE AS TYPE => Type the new name of table if you want
to do so => ok => select the DSN i.e. SUNIL from the box => ok =>
enter the PASSWORD of user =>ok

Open ORACLE & logon to the user i.e The user who's name is type in
the DSN and get all the tables by executing the following

Select table_name from user_tables;

In Oracle the table name will be case senstive so type the table
name in quotas

i.e. select *from "Table1";



Improting from Excel to Oracle

Create a Document/File in Excel => Save it in the default type "SAVE
AS TYPE" in Excel format=> Open MS Access=> Get External Data =>
Import => Choose Microsoft Excel from the FILE OF TYPE => Choose the
File which you want to Import=> Follow each steps of Import
Spreadsheet Wizard => Must Check the box for FIRST ROW CONTAINS
COLUMN HEADING=> After all click on FINISH => File => Save as/Export
=> select "TO AN EXTERNAL FILE OR DATABASE => select ODBC Database
from SAVE AS TYPE => Type the new name of table if you want to do so
=> ok => select the DSN i.e. SUNIL from the box => ok => enter the
PASSWORD of user =>ok






--- In OraTechSupportGroup@yahoogroups.com, "Davinder Sandhu"
<dssandhu@h...> wrote:
> Hi all
>
> I have a schema in Access and want to convert all its tables into
oracle.
>
> Please let me know the way I can convert Access tables into oracle
tables.
>
> I don't want to create oracle tables first, the suggested method
should be
> able to create the target tables in oracle and copy over the data
as well.
>
> Thanks and regards,
>
> Davinder Sandhu
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp