Lotus and Access

  • Thread starter Thread starter Antonio Stroman
  • Start date Start date
A

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
 
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.
Click to expand...

I can't speak to prior versions, but Access directly
imports Lotus 123 files. Or, alternatively, open and then
save the 123 worksheet as an Excel file, and either import
or link to it within Access.

Access menu choice is File, Get External Data.

HTH
Kevin Sprinkel
Becker & Frondorf
 
Hi

You can do a macro in Lotus to export to an Excel spreadsheet.

- I would create a range in the lotus spreadsheet and pick up only the
numbers you need for your reports.
- Export that range as an Excel spreadsheet.
- Link Access to that Excel spreadsheet.

The benefit of doing it this way:
- The data arrangement in the exported Excel spreadsheet will be
predictable, so it's easy to process in Access.
- If there are any changes made by your CFO. A quick push of a button in
Lotus will update the data all the way to you Access database.
- No more printing and reinputing data.


HTH
Immanuel Sibero
 
Back
Top