Hi,
it's not difficult.
Create an ODBC data source for the Oracle database.
Inside Access, highlite the table, choose File - Save As/Export - External File or Database.
In the "File Type" listbox select "ODBC Databases" (very bottom line).
Write down name of the table you want to create in Oracle, select the ODBC source you created.
If prompted, write name/password and confirm.
That's all.
Don't forget that Access creates the table with name exactly as you write it, without conversion tu uppercase. If you write "test" then you'll have to name it "test" in sql. E.g. select * from "test".
With this scenario, memo field is converted to LONG.
If you don't want that, you can pre-create the table with CLOB or VARCHAR2 datatype, connect it into Access and perform "insert into the_connected_table select * from my_access_table". Works with both CLOB and VARCHAR2 datatypes.
Good luck!
Ales
The whole difference between a little boy and an adult man is the price of toys