Home » Infrastructure » Windows » Oracle Insert with sequence via ODBC MS Access
Oracle Insert with sequence via ODBC MS Access [message #127833] Wed, 13 July 2005 10:37
BartB
Messages: 1
Registered: July 2005
Junior Member
Hello everyone,

I have the following problem.
I have an Access Database with a few tables in it and would like to put the data in a Oracle database via ODBC link.
I made the ODBC links to the Oracle tables and made a pass-through Query for a Oracle sequence with Nextval.
i simply want to do a Insert (append) query using the oracle sequence for my ID key.
I've seen work-arounds in VBA to create new records in Oracle using sequences, but it is possible in a normal way ?

Basically I want to export data from MS access to Oracle wich uses sequences, is it possible in a simple way ?

Thanks in advance,

bart
Previous Topic: Oracle 9iR2 Patch Set 9.2.0.4.0
Next Topic: 2147467259 -----[Microsoft][ODBC driver for Oracle]General error
Goto Forum:
  


Current Time: Thu Mar 28 04:19:03 CDT 2024