Lotus and linking to Access Database

To all, I have a CFO who refuses to go the way of Excel. There is a workbook
that he creates and we use it for budget numbers. The problem arises when I
have to use his numbers to create my access reports. The process that I
currently have to endure is to print out his Lotus reports and input that
information into and Excel spreadsheet and then import that table into
Access.

My question is: What is the easier solution?? I would like to link the table
directly into Access so that when he changes the table I don't have to go
through that whole process again.

Thanks in advanced