I need to insert records into Oracle from Access. I have it working
currently, using INSERT INTO one record at a time. I was hoping to find a
better (more efficient) way. I'm only inserting about 25,000 records per
session, across a LAN it takes about 2 minutes. The exact same procedure
across a T1 WAN takes over 2 hours. I believe it is because of the amount
of the ODBC dialog between Access and Oracle.
--
Randy Harris
"Oliver Demus" <oliver_at_demus-online.de> wrote in message
news:62e59750.0302261037.59d9a9c6_at_posting.google.com...
> 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 Thu Feb 27 2003 - 10:50:36 CST
