I have an XLS sheet that i have been using to key in data (using copy/paste to get the repeatitive info in quickly) that I use in the warehouse. the xls has all the same columns that my table has.
what I need to do is a simple "find", then "update" using a command button on a form.
in particular I want to find "file1.serial_#" in table1.serial_#, and then update table1.box_id with file1.box_id
or in english, have the button go record by record finding a match for the data in column J in the datatable column then update the "new" box id number in the table with what is in the xls column