updating oracle table

[joeythelips]

Hi.

I have an oracle database with a table called contracts.
Every customer i have has a contract.
The table has 2 fields:
a/c number
consumption.
I have 400 customers. I have just found out that their data entered consumption is wrong for each one. I now have a list of the proper consumption for each customer.This is in acces and excer.

Does anyone know a way of updating all 400 customers in one go rather than writing 400 update sql statements?

Thanks,

Joe

 

[THoey]

Since you have it in Access, why not link the Oracle table to the access database, and then write one update query:

UPDATE MyOracleTable
SET MyOracleTable.Consumption = MyAccessTable.Consumption
WHERE [MyOracleTable].[a/c number] =
[MyAccessTable].[a/c number]

Just a suggestion, Try to name your fields without spaces and slashes and it will make the script writing easier...


Terry