Re: Oracle7.3 & MS Access

> 1. The table created by MS Access can't be saved into Oracle
>successfully, i.e, sqlplus can not get
> records and structure in the table. However, if you use MS
>Access to open the saved table, all
> the records are there. I wonder whether it's becuase the
>fields in Access are not compatible with
> Oracle.
>
> 2. Aceess seems commit any change right away without waiting for
>user closing the table when
> one opens a table in Oracle. It's quite annoying since I set
>up a trigger which will generate a file
> whenever the table is modified and this trigger will fire
>even a single record is modified.
> I don't know if there is a way to control Access to commit
>changes after one issues a command
> to close the table. Or you might have any better idea?
>
>Any suggestion is truely welcome. Thanks in advance.
>
>
If you you are trying to convert data from Access to Oracle I've done this many times.
[Quoted] 1. create your table in Oracle using SQL*plus. No trigger.

    It is easier if the column names match your access table     and the data types match.
2. Attach to Oracle in Access via ODBC.
3. Create an append query that appends records from Access  to Oracle.
3. Run it.
Done.
I have never created the table directly from Access. If you have access the the Oracle Enterprise Manager, there is a Wizard that does it pretty well too.

Regards,
Tim Received on Sun Jan 25 1998 - 00:00:00 CET