Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scheduled append from Access into Oracle

Status
Not open for further replies.
anniez

anniez

IS-IT--Management
Apr 13, 2001
43
US
How can I schedule an automatic file update from an access file (on a Novell server) into an oracle table?

From the Oracle side? Have the windows scheduler run sql that will truncate and insert?

From the Access side? Run a query that will append into the linked Oracle table?
It's being done manually now by zapping the data and running an Access append query

I don't know the syntax for either.
Thanks
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
317
carp
carp
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
146
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
169
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
426
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
395
carp
carp

Part and Inventory Search

Sponsor

Back
Top