Lotus and Access

[Antonio Stroman]

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

[Michael Hopwood]

Get him to set up an export in text format, then import into access.

--
Michael Hopwood (Phobos)
"Antonio Stroman" <av********@yahoo.com> wrote in message
news:la*****************@bignews1.bellsouth.net...

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

[Roger]

use lotus notes odbc to create a link table to the nsf file..

"Antonio Stroman" <av********@yahoo.com> wrote in message news:<la*****************@bignews1.bellsouth.net>. ..

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