Re: Insert into Oracle from Access

I don´t understand, what you want to do, so, you want to insert records from your Access Database to the Oracle Database? Or insert into Oracle and Access?

Can send you for bóth an example.

Oliver

"Randy Harris" <randy.harris_at_nospam.net> wrote in message news:<U0Y6a.1422$se1.1036652_at_newssvr28.news.prodigy.com>...
> Oliver, thanks so much for your reply, but please pardon my slowness to
> understand. In the example you've provided I can see how this would work to
> do the insert in the remote database. But how would I construct this to
> insert into a table in the remote database, records in a table in the local
> (Access) database?
>
> --
> Randy Harris
>
>
>
> "Oliver Demus" <oliver_at_demus-online.de> wrote in message
> news:62e59750.0302251840.27e95905_at_posting.google.com...
> > Hi there,
> > yes, you can do that with ADO in VBA:
> > here is a small example:
> > Connect these:
> > ' Microsoft ActivX Data Objects (Multi-Dimensional) 2.5
> > ' Microsoft ActivX Data Objects 2.5 Library
> > ' Microsoft ActivX Data Objects Recordset 2.5 Library
> > '
> > '
> > Function InsertData()
> >
> >
> > Dim conn As New ADODB.Connection
> > Dim rs As New ADODB.Recordset
> > conn.Open "DSN=<Database>;UID=<User>;PWD=<Password>"
> > conn.Execute(<Insert-Statement>)
> > conn.Close
> >
> > End Function
> >
> > Hope that helps
> > Oliver
> >
> >
> >
> > "John" <john_at_1startdepot.com> wrote in message
> news:<21ABIqO3CHA.240_at_newsgroup.korea.com>...
> > > Actually there is an easy way, just use DBScripter (www.dkgas.com) this
> way
> > > you can just create insert statements from your Access table and then
> run
> > > them in Oracle.
> > >
> > > John
> > >
> > > "Randy Harris" <randy.harris_at_nospam.net> wrote in message
> > > news:HYz6a.1233$se1.895536_at_newssvr28.news.prodigy.com...
> > > > I posted this question in an Access newsgroup but didn't get an
> answer, I
> > > > thought perhaps the gurus here might know.
> > > >
> > > > Is there any way to do a INSERT into an Oracle table from an Access
> table
> > > > without Linking it in Access. What I had in mind is something like:
> > > >
> > > > INSERT INTO [ocn].OracleTableName
> > > > SELECT Field1, Field2
> > > > FROM LocalTable
> > > >
> > > > where ocn is the Access connection into Oracle.
> > > >
> > > > Is this even possible?
> > > >
> > > > --
> > > > Randy Harris
> > > >
> > > >
> > > >
Received on Wed Feb 26 2003 - 12:37:12 CST