Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Insert into Oracle from Access

Insert into Oracle from Access

From: Randy Harris <randy.harris_at_nospam.net>
Date: Tue, 25 Feb 2003 01:49:27 GMT
Message-ID: <HYz6a.1233$se1.895536@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 Mon Feb 24 2003 - 19:49:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US