robboll wrote:
When I try to use an append query from an oracle link it takes forever.
I am exploring the idea of doing an append action using a pass-through
query.
I'm not sure what you mean by the first sentence - do you mean from
Oracle into Jet? This can take a little while - I used to use Jet make
table queries years when I brought Oracle data from Oracle into Jet.
And of course, I used Jet linked tables.
If I have an Oracle ODBC connection to server OraTest. User: User1
Password: password
For both passthrough queries and linked table queries, the above does
not actually matter in Access itself - it does matter for setting up the
DSN you use.
and I am trying to append all records in table: tblTEST that are code:
"abc"
Is tblTest an Oracle table? What are you "appending" from? Not enough
information.
any suggestions on the SQL code that I need to use for the Access2003
to Oracle9i pass-through query?
What I can tell you is that SQL code in a pass through query in Access
is EXACTLY like you would write using Oracle Forms or what most Oracle
folks are familiar with, SQLPlus. "Append queries" in Oracle are
referred to as insert statements - somewhat similar in structure to a
Jet dialect insert or "append query".
There is a usenet oracle hierarchy: however, I would not ask such a
general there without having done some research first - you'd get
crucified! 8) It's an excellent and huge resource but in contrast to
this newsgroup, the folks there are generally very intolerant of
questions that look like one hasn't visited OTN or read any Oracle on
line documentation.
--
Tim
http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto