Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Insert into Oracle from Access
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 HarrisReceived on Mon Feb 24 2003 - 19:49:27 CST
![]() |
![]() |