Hi everyone,

I have a Access97 database (c:\db\testdb.mdb) contains a table(product) with product numbers (CSPC) and prices (Price) and some other fields.

An Excel97 file (c:\db\priceUpdate.xls) includes a worksheet (NewPrice). There are two columns (CSPC and Price in the worksheet, and start from row 2).

I want to use the Excel prices to update the Access prices; but I don't know how to to code the macro. Can anyone help me out on this issue?

Thank you in advance.