Re: Insert into Oracle from Access

From: Oliver Demus <oliver_at_demus-online.de>
Date: 25 Feb 2003 18:40:46 -0800
Message-ID: <62e59750.0302251840.27e95905@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 - 20:40:46 CST