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.

If you really want to have all the data in the same table, then I think you've already answered your own question - i.e. "update the main table"

Just make sure that you have the fields in the main table, and run an update query.

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends