On fly:
Code:
UPDATE tblCompanyInfo ci INNER JOIN tblCompanyInfo_Modified cim ON cim.PrimaryKey = ci.PrimaryKey
SET
ci.Field1 = cim.Field1,
ci.Field2 = cim.Field2,
...
NB! It updates only records, for which same PrimaryKey (or primary keys complect) exists in both tables. When you have records added or deleted in modified table, you have to run additional APPEND and DELETE queries. And with append query you may have problems, when the PrimaryKey is an autonumber.
With autonumeric primary key, when there are no gaps in primary key numbering, you can also delete all records from tblCompany, reset autonumber so it starts with minimal autonumber value in tblCompanyInfo_Modified, and use an INSET INTO query to fill tblCompanyInfo with data from tblCompanyInfo_Modified.