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 Tue Feb 25 2003 - 23:12:20 CST
