Lotus and Access

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Antonio Stroman
    #1

    Lotus and Access

    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


    Tags: None
    • Michael Hopwood
      #2
      Re: Lotus and Access

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

      --
      Michael Hopwood (Phobos)


      "Antonio Stroman" <avidreader@yah oo.com> wrote in message
      news:laLub.4886 $Cc6.3696@bigne ws1.bellsouth.n et...[color=blue]
      > To all, I have a CFO who refuses to go the way of Excel. There is a[/color]
      workbook[color=blue]
      > that he creates and we use it for budget numbers. The problem arises when[/color]
      I[color=blue]
      > 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[/color]
      table[color=blue]
      > directly into Access so that when he changes the table I don't have to go
      > through that whole process again.
      >
      > Thanks in advanced
      >
      >[/color]


        Comment

        • Roger
          #3
          Re: Lotus and Access

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

          "Antonio Stroman" <avidreader@yah oo.com> wrote in message news:<laLub.488 6$Cc6.3696@bign ews1.bellsouth. net>...[color=blue]
          > 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[/color]

            Comment

            Previous template Next
            Working...