| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
