Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing Access into Oracle
Hi,
Have a look at Oracle Migration WorkBench (technet.oracle.com) or Chyfo
(www.ispirer.com/products)
These tools performs this task.
Best regards, Dmitry.
"GREGORY KNESER" <gregoryk_at_futures.wharton.upenn.edu> wrote in message
news:9o7s6p$e12$1_at_netnews.upenn.edu...
>
> I'm in a situation where we have data in an Access database that is
> maintained by another group. We're trying to set up a connection to this
> database from oracle to get some data out of it without requiring the
> owners of the Access database to do anything. We are using a webserver
> to control the process (kick off stored procs) and we could just as
> easily do something from the webserver if that helped (e.g. get data via
> odbc, dump it to a text file, sql*loader it into the Oracle). The e.g.
> being the one way I've thought of...but it seems like there should be an
> easier way.
>
> Thanks for your help,
> Greg
Received on Wed Sep 19 2001 - 06:38:20 CDT