Re: Insert into Oracle from Access

Randy Harris (randy.harris_at_nospam.net) wrote:
: 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?

I don't remember (I suspect so).

As an alternative however, I'm pretty sure you can use VB to create a link and destroy it later, so even if you access the oracle table through a link it can still be completly under the program's control. Received on Mon Feb 24 2003 - 23:18:45 CST