Data Patch By Batch

[zyus]

I hv this sample table

IDNO ACNO AMT
111 123 10.00
211 5.00
311

If i have the same format structure in excel and all information are filled
in..my question is how to patch (update) the excel data to my access table
thru some automation process if i have more than 1000 records. The key will
be IDNO and the info to be updated are acno and amt.

TQ

 

[Tom van Stiphout]

On Sun, 17 Aug 2008 21:22:11 -0700, zyus

Attach the Excel table. Create an update query and join the two tables
by IDNO. Update the destination table with the fields from the source
table.

-Tom.
Microsoft Access MVP