Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: MSAccess to update Oracle database ???
Stephen,
When you attach to Oracle from Access via ODBC, Access is unable to modify
the Oracle table definition because the table is an "external" one. You'd
have to execute pass-through queries to Oracle, just as if you were typing
them in SQLPlus,
e.g. ALTER TABLE MYTABLE
MODIFY NAME VARCHAR2(50) One can create tables on a back-end in Access via ODBC but, in my experience, the datatype conversions are a bit messy, so one ends up working directly with Oracle in clean-up mode. Here's a timesaving hint: when you create a table in this manner, put a condition on the where clause that causes no (zero) rows to be appended. That way, you will have an empty table on the back-end, which is easier to alter. To discover the syntax for the create-table query using ODBC, check out the online help in Access (the "SELECT INTO" and "IN EXTERNALDATABASE" topics).
Tim Romano
Stephen Meredith <Stephen.Meredith_at_jcu.edu.au> wrote in article
<1997Feb10.064234.18924_at_marlin.jcu.edu.au>...
>
[...]
> Do I have
> to do a 'Create Table...' first then load the data or is MSAccess
> able to do the whole thing as easily as it creates one of its
> own tables (when based on a spreadsheet or ascii file for
> instance) ?
[...]
Received on Sat Feb 15 1997 - 00:00:00 CST