Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Coverting/Exporting Ms Access databases to Oracle 9i?
Thanks !!!
"Glen A Stromquist" <glen_stromquist_at_no_spam_yahoo.com> wrote in message
news:1_o_b.45124$Ff2.2324_at_clgrps12...
> Ana C. Dent wrote:
>
> > Edward Ascencio wrote:
> >
> >> Hi, Guys
> >>
> >>
> >>
> >> How can I condense or convert access databases to oracle 9i?
> >> I know you can import via comma delimited file, or text file but is
> >> there a
> >> new method in converting access db to oracle?
> >>
> >> Any insight would be great ??
> >
> >
> > How about using ODBC from Access to Oracle.
> > Force object names to be all UPPER case in Oracle.
> >
> Or you could set up a heterogeneous service via odbc for the access db,
> create a dblink to the access db and do a "create table <oratable> as
> select * from <accesstable>@<dblink>"
>
Received on Mon Feb 23 2004 - 12:05:02 CST