Hi

I have two tables of exactly the same structure. Table 1 contains 500 lines of data. Table 2 contains one line of data. The two tables have exactly the same primary key ie EENO. I am trying to overwrite the line from table 2 into the corresponding line from table 1 ie the line with the same EENO. I want to keep the other 499 lines as well. Does anyone know the bast way to do this?

Cheers
Tony

__________________
Cheers
Tony

Use an update query where you join table 1 and table 2 by EENO.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division