Re: Insert into Oracle from Access

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 - 10:27:00 CST