Updating Oracle Tables with Access or Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me how to use an Access or an Excel document to update an Oracle table. The Access/Excel files have the same columns as the Oracle tables. I have done it before, but I cannot find my instructions. Can you help. Thanks, -=Dave=-
 
Hi Dave

setup ODBC driver to your oracle database with read/write
access
create a linked file to oracle db
import excel to create a local file of excel data
create an append or update query to read local and update
oracle.

Bit long winded but I have been bitten using other methods

Cheers
Ian
-----Original Message-----
Can anyone tell me how to use an Access or an Excel
Click to expand...
document to update an Oracle table. The Access/Excel
files have the same columns as the Oracle tables. I have
done it before, but I cannot find my instructions. Can
you help. Thanks, -=Dave=-
 
Back
Top