Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import Access into Oracle
Hi,
I don't think there is any straight forward way to do this.
You would have to generate the SQL to create the tables out of MS Access or
write it manually.
Once the tables were created in Oracle then you could use Access and ODBC to
insert all the
data from Access into Oracle, table for table.
Nevin Hahn
nhahn_at_evoke.com
<mhudak00_at_my-deja.com> wrote in message news:8pjgu5$af1$1_at_nnrp1.deja.com...
> I need to know how I can import MS Access into Oracle. Thanks in
> advance.
> M
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 11 2000 - 17:40:29 CDT
![]() |
![]() |