Compact and Repair will make the Access database smaller by eliminating unused space; it also helps to improve the performance of the database.

Excel can throw up various Data type Refresh errors. This post explains each and shows how to fix COULDN'T REFRESH DATA TYPES errors.