I have a database of checks issued. I would like to import the bank data to update the table to show that the checks have been paid and then to generate an outstanding check report. The bank data has check number, paid date, and paid amount. The check number is the key field. What would be the best way to move the paid check data into the table? There are 8-10,000 checks per month, so I would prefer not to have two separate tables, which are joined, but to update the main table.