Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading Access data into Oracle DB
I have also tried "Save As Export"
option in Access which normally creates thetable
in Oracle.
However, occasionally I have found some problems
in some of the tabl;e created, which I suspect is because
of wrongversion of ODBC driver etc.
Insert into linkd tables works quite well Hth
"Yongli Cheng" <ed1_at_idt.net> wrote in message
news:8eo1sq$2jh_at_nnrp4.farm.idt.net...
> link the corresponding tables in Oracle to access database and then you
can
> run query to insert data from access table to oracle table.
>
> <jatin15_at_my-deja.com> wrote in message news:8enjrt$34k$1_at_nnrp1.deja.com...
> > I need to convert MS Access data into Oracle .
> > What Are the options for doing this.......apart from SQL Loader.
> >
> > I used Sql loader & for that I have to convert Access data to a flat
> > file.
> > But when I export(from Access) a table with numeric columns,
> > the values are truncated after second place from decmal,e.g
> > 1.23456 is converted to 1.23 in the flat file.
> >
> > Thanks in advance
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Sat May 06 2000 - 00:00:00 CDT